SAS Advanced Processing Workshop
Duration
Three Days
Description
The course builds upon the concepts presented in the SAS Fundamentals course. Emphasis is placed on efficient data manipulation in the Data Step using SAS functions and SAS programming statements. Data will be summarized both in the Data Step and through the use of PROC Summary.
Audience
This course is designed for the experienced SAS programmer who needs to solve more complex problems.
Pre-requisites
Students are required to have a firm knowledge of SAS or have taken the SAS Fundamentals Workshop.
Objectives
At the completion of this course, the student will be able to:
- Use SAS software to read complex files
- Read and process multiple files
- Understand advanced data step techniques
- Use arrays
- Use DO LOOPS
- Understand advanced formats
- Read, merge and update SAS data sets
- Use functions to manipulate data
- Use the data step to summarize data
- Use PROC SUMMARY to summarize data
- Write efficient programs
Topics
- Review
- External Files
- Functions
- DO Loops and Arrays
- Table Lookups
- Summary Reports
- Efficiencies
- Intro to Macros
- PROC SQL (Optional Day)
- Workshop Practice Problems and Solutions
- Enterprise Guide Overview
