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

Approximate duration:  16 hours

License period:  365 days

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.

Getting Started

• course logistics
• introducing the Structured Query Language
• introducing the business scenario

Basic Queries

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

Displaying Query Results

• presenting data
• summarizing data

Subqueries

• noncorrelated subqueries
• correlated subqueries (self-study)

SQL Joins

• introduction to SQL joins
• complex SQL joins

Set Operators

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

Creating Tables and Views

• creating views with the SQL procedure
• creating tables with the SQL procedure (self-study)
• integrity constraints (self-study)

Additional SQL Procedure Features

• setting SQL procedure options
• dictionary tables and views
• interfacing PROC SQL with the macro language
• program testing and performance

Managing Tables

• introduction to indexes
• creating indexes (self-study)
• maintaining tables

Accessing Relational Databases (Self-Study)

• LIBNAME access to DBMS data
• executing DBMS-specific SQL using the SQL Pass-Through Facility

Learning More

• SAS resources
• beyond this course