PROC SQL using SAS

SAS is a powerful and versatile language for data manipulation, and the ability to implement SQL within SAS creates additional levels of usefulness and flexibility. Not only does PROC SQL often use fewer and shorter statements than built-in SAS procedures, it also often improves the efficiency of the code.

This course provides students with general knowledge of the SQL procedure using SAS software as a database language and the practical skills needed to become proficient using PROC SQL as a programming language. Students will put their newly acquired PROC SQL skills to use in real-world, hands-on programming projects.

Topics include:

• Retrieving, subsetting, ordering, and grouping data
• Logic scenarios with case expressions
• Tables and "virtual" tables
• Aggregating data with summary functions
• DATA step merges and joins
• One-to-one, one-to-many, many-to-one, and many-to-many data relationships
• Complex queries using inner and outer join constructs and set operators
• Producing output using PROC SQL options

Practical experience:

• Hands-on SAS programming projects, using PROC SQL

Software: Students must download and install SAS University Edition. There is no additional cost for this product. Please note, SAS University Edition is required, as not all functions taught in this class can be completed using SAS OnDemand for Academics: Enterprise Guide.

Course typically offered: Online in Fall and Spring

Prerequisites: Completion of SAS Programming II or one year of SAS programming experience required.

Next Steps: Upon completion of this course, consider taking Output Delivery System (ODS) and Data Visualization Essentials using SAS or SAS Macro Programming to continue learning.

More Information: For more information about this course, please contact appliedscience@ucsd.edu. 

Course Number: CSE-41190
Credit: 2.00 unit(s)

+ Expand All

3/27/2023 - 5/8/2023

$625

Online

Closed

• SECTION ID:

  171690

• CLASS TYPE:

  Online Asynchronous.
  
  This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
  You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

• INSTRUCTOR:
  

  Lafler, Kirk, Consultant and Founder of Software Intelligence Corporation; SAS Author

  Kirk Lafler, consultant and founder of Software Intelligence Corporation, has been a SAS user since 1979. As a SAS Certified Professional, Lafler provides IT consulting services and training to SAS users around the world. He is the author of several other books, including "Google Search Complete! (2014)," "PROC SQL: Beyond the Basics Using SAS, Second Edition (2013)," "PROC SQL: Beyond the Basics Using SAS (2004)," "Power AOL and Power SAS," as well as more than 500 papers and articles. He is the recipient of nearly two dozen "best" contributed paper, hands-on workshop (HOW) and poster awards. Lafler is a frequent speaker at international, regional, special-interest, local and in-house SAS Users Group conferences and...Read More

• TEXTBOOKS:

  REQUIRED

  PROC SQL: Beyond the Basics Using SAS, Third Edition 3rd
  by Kirk Paul Lafler
  ISBN / ASIN: 163526684X

  You may purchase textbooks via the UC San Diego Bookstore.

• POLICIES:

  No refunds after: 4/3/2023.
  

• NOTE:

• DATE & LOCATION:

  3/27/2023 - 5/8/2023
  extensioncanvas.ucsd.edu
  You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.