SAS SQL Course Outline
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
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 using joins and set operators.
Create and modify tables and views.
Create data-driven macro variables using a query.
Access DBMS data with SAS/ACCESS technology.
Who this class is for?
SAS programmers, DBAs, and business analysts.
Anyone who is moving from using SQL to SAS.
SAS Fundamentals course
Number of Days
Setting up the course files and library.
Introducing the Structured Query Language.
Overview of the SQL procedure.
PROC SQL Fundamentals
Creating and managing tables.
Using DICTIONARY tables.
Introduction to SQL joins.
Complex SQL joins.
Creating views with the SQL procedure.
Subqueries in the SELECT clause.
Remerging summary statistics.
Introduction to set operators.
The INTERSECT operator.
The EXCEPT operator.
The UNION operator.
The OUTER UNION operator.
Using and Creating Macro Variables in SQL
Interfacing PROC SQL with the macro language.
Creating data-driven macro variables with a query.
Using macro variables in SQL.
View outline in Word