Improving SAS Program Efficiency
PEFF : PEFFV1
Learn How To
- Understand how SAS compiles and executes DATA steps to make smarter programming decisions.
- Reduce runtime by optimizing data access, controlling I/O, and minimizing unnecessary processing.
- Apply efficient coding techniques such as indexing, streamlined conditional logic, and strategic statement placement.
- Evaluate existing programs to identify resource constraints and implement practical strategies that improve performance at scale.
Who Should Attend
This course is designed for SAS programmers who routinely work with large data sets, long-running programs, or resource-intensive processes and are looking to reduce runtime, and optimize the way SAS handles data.
Prerequisites
SAS Programming 1: Essentials
Macro and PROC SQL experience preferred
SAS Products Covered
Base SAS
Course Outline
- Computer Resources
- Understanding Computer Resources and Benchmarking SAS Programs
- Controlling Input/ Output
- Reading SAS Data
- Working with the SASFILE Statement
- Using Statements and Data Set Options Strategically
- Reducing Data Set Size
- Reducing Variable Length
- Compressing SAS Data Files
- Using SAS Views
- Indexes
- Creating and Using an Index