Target group
Business analysts and SAS programmers
Course structure
Controlling DATA Step Processing
- Setting up for this course.
- Understanding DATA step processing.
- Directing DATA step output.
Summarizing Data
- Creating an accumulating column.
- Processing data in groups.
Manipulating Data with Functions
- Understanding SAS functions and CALL routines.
- Using numeric and date functions.
- Using character functions.
- Using special functions to convert column type.
Creating Custom Formats
- Creating and using custom formats.
- Creating custom formats from tables.
Combining Tables
- Concatenating tables.
- Merging tables.
- Identifying matching and nonmatching rows.
Processing Repetitive Code
- Using iterative DO loops.
- Using conditional DO loops.
Restructuring Tables
- Restructuring data with the DATA step.
- Restructuring data with the TRANSPOSE procedure.
