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 Formats available Duration
: 4 x 3.5 sessions
: 14 hours/180 days license

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 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.

Introduction

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

Basic Queries

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

Displaying Query Results

• presenting data
• summarizing data

SQL Joins

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

Subqueries

• noncorrelated subqueries
• in-line views

Set Operators

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

Creating Tables and Views

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

Advanced PROC SQL Features

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

Learning More

• SAS resources
• beyond this course

SQ1.