This course is for users who want to learn more advanced functionality for writing SAS programs, with a focus on applying efficiency techniques, using SAS macro code, and processing SAS data using Structured Query Language (SQL). The "fast track" format for this offering combines the SAS Programming 3: Advanced Techniques, SAS Macro Language 1: Essentials, and SAS SQL 1: Essentials courses. The course provides an introduction to SQL processing, and access to the e-learning version of the Essentials course is provided so that students can study the subject matter independently.
Learn how to
- Prepare data for analysis.
- Evaluate manipulation techniques and resource cost benefits to help you choose the most appropriate technique for your data situation.
- Recognize the components of the SAS macro facility.
- Design, write, and debug macro systems.
- Explain how programs that contain macro code are processed.
- Process SAS data using SQL.
Who should attend
Experienced SAS programmers
This course is not appropriate for beginning SAS software users. Before attending this course, you should have at least several months of SAS programming experience, or you should have completed the SAS Programming 2: Data Manipulation Techniques course and master the topics introduced during that course.
This course addresses Base SAS software.
This course is appropriate for students who are using SAS 9 software.
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
