Summer Fast Track: SAS(R) Advanced Programming

Target group

Course structure

Introduction to SAS Programming 3

• Overview of SAS Foundation.
• Course logistics.
• Creating the course data.

Efficient SAS Programming

• Identifying computer resources related to efficiency.

Controlling I/O Processing and Memory

• SAS DATA step processing.
• Controlling I/O.
• Reducing the length of numeric variables.
• Compressing SAS data sets.
• Using SAS views.

Accessing Observations

• Access methods.
• Accessing observations by number.
• Creating an index.
• Using an index.

DATA Step Arrays

• Introduction to lookup techniques.
• One-dimensional arrays.
• Multidimensional arrays.
• Loading a multidimensional array from a SAS data set.

DATA Step Hash and Hiter Objects

• Introduction.
• Hash object methods.
• Loading a hash object from a SAS data set.
• DATA step hiter object.

Combining Data Horizontally

• DATA step merges and SQL procedure joins.
• Using an index to combine data.
• Combining summary and detail data.
• Combining data conditionally.

User-Defined Functions and Formats

Combining Raw Data Files Vertically

Introduction to SAS Macro

• Overview of SAS Foundation.
• Course logistics.
• Purpose of the macro facility.
• Program flow.

Macro Variables

• Introduction to macro variables.
• Automatic macro variables.
• Macro variable references.
• User-defined macro variables.
• Delimiting macro variable references.
• Macro functions.

Macro Definitions

• Defining and calling a macro.
• Macro parameters.

DATA Step and SQL Interfaces

• Creating macro variables in the DATA step.
• Indirect references to macro variables.
• Creating macro variables in SQL.

Macro Programs

• Conditional processing.
• Parameter validation.
• Iterative processing.
• Global and local symbol tables.

Supplemental Materials: Program Flow

Introduction to SAS SQL Procedures