SAS® Programming 1: Essentials
Lesson 1 Essentials
- The SAS Programming Process
- Using SAS Programming Tools
- Understanding SAS Syntax
Lesson 2 Accessing Data
- Understanding SAS Data
- Accessing Data through Libraries
- Importing Data into SAS
Lesson 3 Exploring and Validating Data
- Exploring Data
- Filtering Rows
- Formatting Columns
- Sorting Data and Removing Duplicates
Lesson 4 Preparing Data
- Reading and Filtering Data
- Computing New Columns
- Conditional Processing
Lesson 5 Analyzing and Reporting on Data
- Enhancing Reports with Titles, Footnotes, and Labels
- Creating Frequency Reports
- Creating Summary Statistics Reports
Lesson 6 Exporting Results
- Exporting Data
- Exporting Reports
SAS® Programming 2: Data Manipulation Techniques
Lesson 1 Controlling DATA Step Processing
- Setting Up for This Course
- Understanding DATA Step Processing
- Directing DATA Step Output
Lesson 2 Summarizing Data
- Creating an Accumulating Column
- Processing Data in Groups
Lesson 3 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
Lesson 4 Creating Custom Formats
- Creating and Using Custom Formats
- Creating Custom Formats from Tables
Lesson 5 Combining Tables
- Concatenating Tables
- Merging Tables
- Identifying Matching and Nonmatching Rows
Lesson 6 Processing Repetitive Code
- Using Iterative DO Loops
- Using Conditional DO Loops
Lesson 7 Restructuring Tables
- Restructuring Data with the DATA Step
- Restructuring Data with the TRANSPOSE Procedure