This course teaches you how to process SAS data using Structured Query Language (SQL).

This course can help prepare you for the following certification exam(s): SAS Certified Advanced Programmer for SAS 9.

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

Formats available	Standard Duration
Classroom:	2.0 days
Live Web Classroom:	5 half-day session(s)	System Requirements
e-Learning:	14 hours/180 day license	System Requirements

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.

• overview of SAS Foundation
• course logistics
• course data files
• introducing the Structured Query Language

• overview of the SQL procedure
• specifying columns
• specifying rows

• presenting data
• summarizing data

• introduction to SQL joins
• inner joins
• outer joins
• complex SQL joins

• noncorrelated subqueries
• in-line views

• introduction to set operators
• the UNION operator
• the OUTER UNION operator
• the EXCEPT operator
• the INTERSECT operator

• creating tables with the SQL procedure
• creating views with the SQL procedure

• dictionary tables and views
• using SQL procedure options
• interfacing PROC SQL with the macro language

• SAS resources
• beyond this course