SAS Certified Specialist Exam
  • ​Exam Prep Course (20 modules)

200+ Sample Questions and Practice Exercises

The Ultimate SAS Certified Specialist Exam Training Program

​The Ultimate SAS Certified Specialist Training Program includes two full courses covering each and every topic in the certification exam.
You will be familiar with the exam structure and question styles, with 200+ sample exam questions.
This is the only study material you need to achieve a great result on the rigorous certification exam.​
Pick a course:
Training program includes ...
Two Certificate Prep Courses and 300+ Practice Exercises
Certificate Prep Course 1
This course aims to help you build a solid foundation of SAS base programming. It includes 150+ practice exercises and sample exam questions using our interactive platform.
Certificate Prep Course 2
This course covers all the new topics in the SAS certified specialist base programming exam, including Proc Import, Debugging Errors and Advanced Data Manipulations.
300+ Practice Exercises
The 300+ practice exercises and sample exam questions will help you prepare for the coding and the multiple-choice part of the SAS certified specialist exam.
 
Do you know that the SAS certified specialist exam now requires you to write and execute code in the exam?
 
How to use this certificate training program.
There are two courses that you need to complete when preparing for the exam.
The Practical SAS Training Course for Beginners helps you get familiar with the programming language. The SAS Certified Specialist Exam Prep Course prepares you for the more advanced topics that will appear on the exam.
On top of that, the training program includes 300+ practice exercises that will turn you into a proficient SAS programmer who is more than capable of passing the exam on your first try!
300+ Practice Exercises
Practicing writing your own code is the key to achieving a great result in the exam. Get 300+ practice exercises from our SAS base certification course and turn yourself into a proficient SAS programmer in 30 days!
Quality Materials
Getting tired of materials that put you to sleep? Our training materials are written in layman terms that even SAS beginners can easily understand. You'll be ready for the SAS base exam in as little as two weeks.
Real-time Learning Support
The SAS base exam covers a wide range of topics, and you'll encounter some confusing concepts along the way. Simply send us a quick message and one of our experienced instructors will give you a hand!
Course 1: The Practical SAS Training Course for Beginners
The SASCrunch Practical SAS Training Course for Beginners is an interactive SAS training course that allows you to learn and practice SAS at the same time and on the same screen.
It includes 7 complete modules with 150+ coding exercises and 5 coding projects.
You can learn SAS from scratch and become an intermediate SAS programmer in just 30 days.​
or see course outline
Table of Contents

​Module 0: How to start (free)

Module 1: SAS Interface (free)
  • Code Tab
  • Log Tab
  • Error and Warning Message
  • Library
  • Data Set
  • Summary
  • Final Test
  • End of Module


Module 2: Data Set (free)
  • Create a Data Set
  • Programming Tips #1
  • Programming Tips #2
  • Character Variable
  • Creating Multiple Observations
  • Programming Tips #3
  • Character Variable II
  • Data Truncation
  • Copying Data Set
  • Subsetting Data Set
  • Assessing Other Libraries
  • Programming Tips #4
  • Accessing your Own Data Set I
  • Accessing your Own Data Set II
  • Saving a Data Set
  • Exporting Data Set I
  • Exporting Data Set II
  • Exporting Data Set III
  • Summary
  • Final Test
  • Coding Exercises
  • Coding Project
  • End of Module


Module 3: SAS Functions
  • Mathematical Operators
  • Programming Tips #5
  • SUM Function
  • MEAN, MIN and MAX Functions
  • RAND Function
  • ROUND Function
  • FLOOR Function
  • SUBSTR Function
  • LENGTH Function
  • Combining Character Variables
  • INDEX Function
  • INDEXC Function
  • UPCASE, LOWCASE and PROPCASE Functions
  • RENAME, KEEP and DROP Statements
  • If-then statement
  • Summary
  • Final Test
  • Coding Exercise
  • Coding Project
  • End of Module


Module 4: Variable Attributes
  • The 6 Attributes of SAS Variables
  • Proc Contents
  • Programming Tips #6
  • Attribute #1: Variable Name
  • Attribute #2: Variable Label
  • Attribute #3: Variable Type (Numeric)
  • Attribute #3: Variable Type (Character)
  • Attribute #4: Variable Length
  • Attribute #5: Variable Format
  • Programming Tips #7
  • The Format of W.D
  • Comma. and Dollar. Format
  • Understand how SAS keep track of Date and Time
  • Date & Time Format
  • Creating your own format
  • (Best.) Format
  • Summary of Variable Formats
  • PUT Function
  • INPUT Function
  • Programming Tips #8
  • Summary
  • Final Test
  • Coding Exercise
  • End of Module


Module 5: Data Manipulations
  • Sorting the Data Set
  • Creating Output Data Set
  • Programming Tips #9
  • Removing Duplicate Observations
  • Flagging Extreme Values
  • Flagging Extreme Values II
  • Data Set Concatenation
  • Two (2) common issues when concatenating data sets
  • Merging data sets
  • Identifying the Merging Variable(s)
  • Programming Tips #10
  • Dealing with unmatched observations
  • (In=) Option
  • Transposing Data Set
  • Tips for Proc Transpose
  • Reverse Transpose
  • Variable _n_ and _error_
  • Retain Statement
  • Assigning initial values with Retain Statement
  • (+) Expression
  • Summary
  • Final Test
  • Coding Exercise
  • Coding Project I
  • Coding Project II
  • Coding Project III
  • End of Module


Module 6: Data Analysis
  • Proc Univariate
  • Programming Tips #11
  • Normality Test
  • Analyzing Multiple Segments
  • Output Statement
  • Programming Tips #12
  • Proc Means
  • Additional Statistics
  • Classification Variable
  • Programming Tips #13
  • Working with Multiple Analysis Variables
  • Output Statement II
  • Output Data Set
  • Proc Freq
  • Histogram
  • WEIGHT Statement
  • N-way Crosstabulation Table
  • (OUT=) Option
  • Summary
  • Final Test
  • Coding Exercise
  • End of Module

​
Module 7: Hypothesis Testing Using SAS
  • Hypothesis Testing (mini training)
  • One-sample t-test
  • One-sided t-test
  • Paired t-test
  • Two-sample t-test
  • ODS Output
  • Chi-square Test of Independence
  • Correlation Analysis
  • Programming Tips #14
  • Summary
  • Final Test
  • Coding Exercise
  • Coding Project
  • End of Training​
Course 2: The SAS Certified Specialist Training Prep Course
The SAS Certified Specialist Exam Prep Course is the complete prep course that covers the rest of the exam topics for the SAS certified specialist exam.
This course focuses on both the practical application of SAS code as well as exam questions that commonly appear in the exam.
or see course outline
Table of Contents
  • Module 0: How to Start
  • Module 1: Proc Import
  • Module 2: Debugging Errors
  • Module 3: Data Step Processing
  • Module 4: Library
  • Module 5: Data Set
  • Module 6: Output Statement
  • Module 7: Keep, Drop, Rename Statement
  • Module 8: If-then Statement
  • Module 9: Where Statement
  • Module 10: Set Statement
  • Module 11: Merge Statement
  • Module 12: Proc Print
  • Module 13: By Group Processing
  • Module 14: Numeric Functions
  • Module 15: Character Functions
  • Module 16: Input & Put Functions
  • Module 17: Handling Date Values
  • Module 18: Advanced Data Manipulations
  • Module 19: Simple Macro
  • Module 20: Output Delivery System (ODS)

​Sample Exam Questions & Practice Exercises