SAS® 9.4 Cert Prep: Part 04 Preparing Data

Prepare to take the SAS 9.4 certification exam. Learn how to prepare data for analysis, in this SAS Institute cert prep course.

Introduction

• Sort and validate your data

1. Reading and Filtering Data

• Using the DATA step to create a SAS data set
• DATA step processing
• Demo: Working with the DATA step

2. Computing New Columns

• Demo: Using expressions to create new columns
• Using Numeric functions to create columns
• Demo: Using character functions
• Demo: Using date functions

3. Conditional Processing

• Demo: Conditional processing with IF-THEN
• Conditional processing with IF-THEN/ELSE
• Creating character columns with the LENGTH statement
• Processing multiple statements with IF-THEN/DO
• Demo: Processing multiple statements with IF-THEN/DO