Agenda:

• Use SAS options to evaluate efficiency when accessing database data.
• Tune SAS programs for faster processing.
• Understand how relational database tables are accessed on the SAS Compute Server and in SAS Cloud Analytic Services (CAS).
• Understand conditions that can prevent SQL pass-through for execution in the database.
• Modify SAS programs to maximize pass-through to the database and minimize execution time.

Who Should Attend:

Experienced SAS Programmers, Data Scientists, Data Analysts who want to use SAS Studio as a programming interface.

Prerequisites:

Before attending this course, you should either have at least six months of experience writing SAS programs that include PROC SQL code or have completed the SAS SQL 1: Essentials course and used PROC SQL in SAS for at least one month.