SAS® 9.4 Cert Prep: Part 03 Exploring and Validating Data
41mBeginner2020-01-06
Authors

SAS Institute
Business analytics software and services
Course details
Want to get ahead in a crowded job market? Get certified with SAS. This course is part of a series by the SAS Institute, designed to prepare you for the SAS 9.4 certification exam. One of the most important steps to take with your data is knowing how to find and format it in a useful way. The following videos introduces you to the ways that SAS can help you explore your data. Instructor Stacey Syphus explains how to use procedures, filter rows with the WHERE statement, create and use macro variables, format columns, sort data, and remove duplicates.
Skills covered
SASStatisticsData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and Tools
Concepts
0. Introduction
- 01 - Sort your data with SAS
1. Exploring Data
- 02 - Exploring data with procedures
- 03 - Demo - Exploring data with SAS procedures
2. Filtering Rows
- 04 - Filtering rows with the WHERE statement
- 05 - Combining expressions in a WHERE statement
- 06 - Demo - Filtering rows with basic operators
- 07 - Using special WHERE operators
- 08 - Creating and using macro variables
- 09 - Demo - Filtering rows using macro variables
3. Formatting Columns
- 10 - Formatting data values in results
- 11 - Common formats for numeric values
- 12 - Common formats for date values
- 13 - Demo - Formatting data values in results
4. Sorting Data and Removing Duplicates
- 14 - Sorting data
- 15 - Identifying and removing duplicates
- 16 - Demo - Identifying and removing duplicate values
Related courses
- SAS® 9.4 Cert Prep: Part 06 Exporting Results
- SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
- SAS® 9.4 Cert Prep: Part 09 Summarizing Data
- SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
- SAS® 9.4 Cert Prep: Part 01 SAS Programming Essentials
- SAS® 9.4 Cert Prep: Part 02 Accessing Data
- SAS® 9.4 Cert Prep: Part 05 Analyzing and Reporting on Data
- SAS® 9.4 Cert Prep: Part 08 Controlling Data Step Processing