DS 7120: Advanced Programming in SAS

3 Credit Hours
Prerequisite: STAT 7100 and DS 7020
This course will cover advanced programming techniques using the SAS system for data management and statistical analysis. The topics covered include macro programming, using SQL with SAS and optimizing SAS programs. Upon completion of this course students will be prepared to take and pass the certification test and obtain the Advanced Programmer for SAS 9 certification.

Course Learning Outcomes
Students who successfully complete this course will be able to:

Generate detail reports by working with a single table, joining tables, or using set operators in SQL.
Generate summary reports by working with a single table, joining tables, or using set operators in the SQL.
Construct sub-queries and in-line views within an SQL procedure step.
Use SAS SQL procedure enhancements.
Create and use user-defined and automatic macro variables within the SAS Macro Language.
Automate programs by defining and calling macros using the SAS Macro Language.
Use macro functions.
Debug Macros.
Create data-driven programs using SAS Macro Language.
Process data using 1 and 2 dimensional arrays.
Process data using hash objects.
Use SAS utility procedures.
Use Advanced functions.