Target group
Experienced SAS programmers
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.
