SAS® Programming 3: Advanced Techniques
PROG3 : PG3M6
This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS Programming 2: Data Manipulation Techniques course.
Learn How To
- Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW).
- Perform pattern matching using PRX functions.
- Process repetitive code, rotate data, and perform table lookups using arrays.
- Perform table lookups and sort data using hash and hash iterator objects.
- Create numeric templates using the FORMAT procedure.
- Create custom functions using the FCMP procedure.
Who Should Attend
Experienced SAS programmers
Prerequisites
Before attending this course, you should have completed the SAS Programming 2: Data Manipulation Techniques course or have equivalent knowledge. Specifically, you should be able to do the following:
- Create an accumulating column and process data in groups.
- Manipulate data with functions.
- Convert column types.
- Create custom formats.
- Concatenate and merge tables.
- Process repetitive code.
- Restructure tables.
SAS Products Covered
Base SAS
Course Outline
Getting Started
- Setting up for this course.
- DATA step review.
- Using a variety of advanced functions.
- Performing pattern matching with Perl regular expressions.
- Defining and referencing one-dimensional arrays.
- Doing more with one-dimensional arrays.
- Defining and referencing two-dimensional arrays.
- Declaring hash objects.
- Defining hash objects.
- Finding key values in a hash object.
- Writing a hash object to a table.
- Using hash iterator objects.
- Creating picture formats with the FORMAT procedure.
- Creating functions with the FCMP procedure.
Live Class Schedule
Duration: 14 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
08-12 DEC 2025
Live Web, US
1:00 PM-4:30 PM EST
English
1,600 USD
12-16 JAN 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
02-06 FEB 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
17-20 FEB 2026
Live Web, US
9:30 AM-2:00 PM EST
Spanish
1,600 USD
02-06 MAR 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
01-04 JUN 2026
Live Web, US
10:30 AM-3:00 PM EDT
Spanish
1,600 USD
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.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring 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.
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
