Target group
Anyone starting to write SAS programs
Course structure
Essentials
- The SAS programming process.
- Using SAS programming tools.
- Understanding SAS syntax.
Accessing Data
- Understanding SAS data.
- Accessing data through libraries.
- Importing data into SAS.
Exploring and Validating Data
- Exploring data.
- Filtering rows.
- Formatting columns.
- Sorting data and removing duplicates.
Preparing Data
- Reading and filtering data.
- Computing new columns.
- Conditional processing.
Analyzing and Reporting on Data
- Enhancing reports with titles, footnotes, and labels.
- Creating frequency reports.
- Creating summary statistics reports.
Exporting Results
- Exporting data.
- Exporting reports.
Using SQL in SAS
- Using Structured Query Language in SAS.
- Joining tables using SQL in SAS.
Restructuring Tables
- Restructuring data with the DATA step.
- Restructuring data with the TRANSPOSE procedure.
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.
