SAS® 9.4 Cert Prep: Part 03 Exploring and Validating Data

Prepare to take the SAS 9.4 certification exam. Learn how to explore and validate SAS data, in this SAS Institute cert prep course.

Introduction

• Sort your data with SAS

1. Exploring Data

• Exploring data with procedures
• Demo: Exploring data with SAS procedures

2. Filtering Rows

• Filtering rows with the WHERE statement
• Combining expressions in a WHERE statement
• Demo: Filtering rows with basic operators
• Using special WHERE operators
• Creating and using macro variables
• Demo: Filtering rows using macro variables

3. Formatting Columns

• Formatting data values in results
• Common formats for numeric values
• Common formats for date values
• Demo: Formatting data values in results

4. Sorting Data and Removing Duplicates

• Sorting data
• Identifying and removing duplicates
• Demo: Identifying and removing duplicate values