search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

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

Duration:  2 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.

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

Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year. The course requires only a standard Web browser and a free Flash plug-in. The course includes data that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions, step-by-step demonstrations, and a Certificate of Completion.

This course addresses Base SAS. This course is appropriate for students who are using SAS 8 or SAS 9 software.

You should

• use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
• have the latest version of Macromedia Flash Player installed
• have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.