SAS® Programming 2 Case Study
PG2CS : PG2CS
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
- 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.
- Create and use a custom format.
- Sort data to prepare for merge.
- Merge tables and identify matching rows.
- Restructure data with the TRANSPOSE procedure.
- Manipulate transposed data to make meaningful reports.
Live Class Schedule
Duration: 7 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Coaching Services
Take your training to the next level with personalized coaching. While private training offers structured coursework, coaching provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.