There is a new version of this course. Please see SAS SQL 1: Essentials.
This course teaches you how to process SAS data using Structured Query Language (SQL).
Learn how to
- query and subset data
- summarize and present data
- combine tables, including complex joins and merges
- create and modify table views and indexes
- replace multiple DATA and PROC steps with one SQL query.
Who should attend
SAS programmers and business analysts
Before attending this class, you should be able to
- submit SAS programs on your operating system
- create and access SAS data sets
- use arithmetic, comparison, and logical operators
- invoke SAS procedures.
You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary.
This course addresses Base SAS software.
This course is appropriate for students who are using SAS 9 software.
- course logistics
- introducing the Structured Query Language
- introducing the business scenario
Displaying Query Results
- overview of the SQL procedure
- specifying columns
- specifying rows
- presenting data
- summarizing data
- noncorrelated subqueries
- correlated subqueries (self-study)
- introduction to SQL joins
- complex SQL joins
Creating Tables and Views
- introduction to set operators
- the EXCEPT operator
- the INTERSECT operator
- the UNION operator
- the OUTER UNION operator
Additional SQL Procedure Features
- creating views with the SQL procedure
- creating tables with the SQL procedure (self-study)
- integrity constraints (self-study)
- setting SQL procedure options
- dictionary tables and views
- interfacing PROC SQL with the macro language
- program testing and performance
Accessing Relational Databases (Self-Study)
- introduction to indexes
- creating indexes (self-study)
- maintaining tables
- LIBNAME access to DBMS data
- executing DBMS-specific SQL using the SQL Pass-Through Facility
- SAS resources
- beyond this course