This course is designed to apply knowledge gained from SAS Programming 2: Data Manipulation Techniques to a comprehensive case study project. It includes a review of SAS Programming 2 material along with the case study where you will use the DATA step and procedures to prepare, merge, transpose and summarize real data. The course builds on the concepts that are presented in the SAS Programming 2 and SAS Programming 1: Essentials course and is not recommended if you have not taken the prerequisites.
Learn How To
Apply your skills from SAS Programming 2
Understand and control DATA step processing
Manipulate data with functions
Convert column type
Create custom formats
Merge tables
Conditionally process data
Restructure tables
Who Should Attend
Business analysts and SAS programmers
Prerequisites
SAS Programming 1: Essentials
SAS Programming 2: Data Manipulation Techniques
SAS Products Covered
Base SAS
Course Outline
Case Study Kickoff
Data Discovery
SAS Programming 2 Review
Prepare Data
Manipulate data with functions.
Use special functions to convert column type.
Direct DATA step output.
Use conditional processing.
Apply SAS formats.
Use assignment statements to create new columns.
Merge Data
Create and use a custom format.
Sort data to prepare for merge.
Merge tables and identify matching rows.
Transpose and Report
Restructure data with the TRANSPOSE procedure.
Manipulate transposed data to make meaningful reports.
Live Instructor Dates