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 Advanced Programming 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
SAS programmers and business analysts
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.