Welcome to ONLC Training Centers

SAS Programming Intermediate (Test-Prep for the SAS Associate and SAS Specialist Certificates)

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $1195

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.

SAS Programming Intermediate (Test-Prep for the SAS Associate and SAS Specialist Certificates) Course Outline

This course provides a review of the majority of topics in the SAS 9.4 Base Programming Performance-Based Exam. It addresses the four exam content areas: Accessing and Creating Data Structures, Managing Data, Generating Reports and Output, and Handling Errors.

This course can help prepare you for the following certification exam(s): SAS Certified Specialist: Base Programming Using SAS 9.4.

Learn how to:
• Read, create, and combine SAS data sets.
• Sort observations with the SORT procedure.
• Read delimited data and Microsoft Excel files with the IMPORT procedure and the LIBNAME engine.
• Create variables using assignment, conditional, and sum statements.
• Manipulate data using SAS functions.
• Process data with DO loops.
• Restructure data with the TRANSPOSE procedure.
• Create reports using the PRINT procedure, the FREQ procedure, the MEANS procedure, and the UNIVARIATE procedure.
• Create formats with the FORMAT procedure.
• Create external files with ODS, the EXPORT procedure, and the LIBNAME engine.
• Identify and resolve programming logic errors.

Who this class is for?
SAS users who are interested in a review course before taking the SAS 9.4 Base Programming Performance-Based Exam, part of the SAS Global Certification Program, SAS programmers, DBA’s, business analysts., and data scientists.

SAS Fundamentals course or equivalent.

Number of Days
3 days


• Specifics about the SAS 9.4 Base Programming Performance-Based Exam.
• Specifics about this review course.
• Review SAS fundamental concepts.
• Using macro variables to simplify code maintenance.

Access and Create Data Structure
• Investigating SAS data libraries.
• Accessing SAS data sets and data sources not in SAS (Microsoft Excel and text files).
• Creating SAS data sets and reviewing DATA step processes.
• Controlling rows and columns to process and output.
• Modifying column attributes.

Manage Data
• Using assignment statements.
• Conditional processing with IF-THEN/ELSE.
• Sorting and combining tables.
• Accumulating subtotals and totals.
• Manipulating data with functions.
• Iterative processing with DO loops.
• Restructuring data with PROC TRANSPOSE.

Error Handling
• Identifying and resolving programming logic errors.
• Examining and resolving data errors.

Generating Reports and Output
• Generating list reports using the PRINT procedure.
• Generating summary reports and frequency tables using Base SAS procedures.
• Enhancing reports with labels, SAS formats, user-defined formats, titles, footnotes, and SAS reporting options.
• Generating reports using ODS statements.
• Exporting data to text and Microsoft Excel files.

Additional Information
• More specifics about the SAS 9.4 Base Programming Performance-Based Exam.
• Additional preparation resources.
• Test-taking strategies.

View outline in Word


Attend hands-on, instructor-led SAS Programming Intermediate (Test-Prep for the SAS Associate and SAS Specialist Certificates) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

First Name

Last Name