Data Analytics with SAS

The Data Analytics with SAS program is a great place for a beginner in data analysis to start with. It will provide the chance to test the knowledge you have gained from the SAS training classes and demonstrate that how much you have understood the fundamentals of SAS programming. Candidates will learn the SAS 9.4 programming skills. You will explore and also access SAS data sets. You will control data execution with the use of loops and conditional iterations. You can manipulate data with formulas and assignment statements. You will sort and format SAs data with the Base SAS procedures.


Agenda/Schedule of Training

  • This exam is administered by SAS and Pearson VUE.
  • 60-65 multiple-choice and short-answer questions. (must achieve a score of 68% to pass)
  • 120 minutes
  • Use exam ID A00-215; required when registering with Pearson VUE
  • This exam is based on SAS 9.4 M5


  • SAS Programming 1: Essentials
  • SAS Programming 2: Data Manipulation Techniques


  • SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4

Fundamental SAS Concepts

  • Recall general rules of DATA and PROC steps
  • Recognize general rules of SAS statements including global statements
  • Interpret the SAS log
  • Distinguish between syntax and logic errors

Explore SAS Data Sets

  • Recall naming conventions used for SAS data sets and variables
  • Recognize variable types (character and numeric)
  • Explain how to create and manipulate SAS date values
  • Recognize how SAS stores missing data
  • Use the LIBNAME statement to read SAS data sets
  • Use PROC CONTENTS to view the descriptor portion of a data set
  • Recall how to use Data Set options: DROP=, KEEP=, RENAME=, OBS=

Using the DATA Step to Access SAS Data Sets

  • Use the DATA statement to create one or multiple data sets
  • Use the SET statement to read a data set
  • Explain how to combine data sets
  • Explain the compilation and execution process of the DATA step
  • Subset observations and variables

Using the DATA Step to Manipulate Data

  • Create or update variables
  • Recognize SAS Functions
  • Perform conditional processing
  • Control the output of observations
  • Create an accumulating variable
  • Explain the function of iterative DO loops
  • Assign permanent attributes

Generate Reports Using PROC Steps

  • Use PROC PRINT to generate a detail report
  • Use PROC MEANS to generate a summary report
  • Use PROC FREQ to generate a frequency report
  • Identify methods to enhance reports

Use Utility Procedures

  • Use PROC SORT to sort a report based on values of a variable
  • Use PROC FORMAT to define custom formats

Import and Export non-SAS files

  • Use a procedure to transfer a CSV file
  • Use the LIBNAME statement to import/export an Excel file with XLSX engine
  • Use ODS to direct reports to external files


The content covered by the prep guide for the Base Programming Specialist is also appropriate for preparing for this Associate level credential. This associate-level credential will not include performance-based items.

Who Should Learn this?

This course can be taken up by Software Developers and BI and Analytics, ETL, SQL, Data Warehouse, Mainframe, and Testing Professionals.




 What are the benefits of Data Analytics for Lean Six Sigma? 

The Data Analytics for Lean Six Sigma certification will enhance your career opportunities. It enables you to be recognized as a professional who has enough experience in the field of project management and data analysis. You will learn many new skills that will enhance your knowledge in the field. The certification also enables you to earn more.

How can I prepare for the Exam?

Make sure to use a good Data Analytics for Lean Six Sigma preparation book to build your confidence and knowledge towards the exam. You can also try Data Analytics for Lean Six Sigma exam prep workshops and online practice exams.

When can I take the exam?

You can take the exam whenever you are ready, all you need to do is schedule a date from the nearest PMP test center.

Can I retake the exam if I fail?

Yes, if you fail in your first attempt, you can retake the exam for up to two more times within the one year eligibility period.

How much salary will I get after doing this course?

Based on research and analysis, it is seen that Data Analytics for Lean Six Sigma professionals seem to earn 30% more than non-certified professionals in the field of project management.

Is Data Analytics for Lean Six Sigma really worth it?

Yes, it helps to improve your career and your job prospects. It boosts your chances to land a job and also make you much more valued.

Will Data Analytics for Lean Six Sigma help me get my dream job?

Yes, this depends if your dream job is one in the field of project management and data analysis as the Data Analytics for Lean Six Sigma is a certification that enhances your chances in the project management scene.

Download Data Analytics with SAS Course Content Here