• Print  |
  • Feedback  |

Training & Books


SAS Global Certification program


SAS Certified Advanced Programmer for SAS 9 Credential

Represents the upper echelon of SAS programmers who demonstrate a high level of proficiency in SAS programming expertise

Successful candidates should be skilled in tasks such as
  • using advanced DATA step programming statements and efficiency techniques to solve complex problems
  • writing and interpreting SAS SQL code
  • creating and using the SAS MACRO facility.

Required Exam

Candidates who earn this credential will have taken and earned passing scores of the following two exams: 1) SAS Base Programming for SAS 9 exam, and 2) SAS Advanced Programming for SAS 9 exam. This exam is administered by SAS and Pearson VUE.
  • 60-65 multiple-choice and short-answer questions (must achieve score of 65% correct to pass)
  • 2 hours to complete exam
  • Use exam ID A00-212; required when registering with Pearson VUE.
  • This exam is based on SAS 9.4

Exam topics include:

Accessing Data Using SQL
  • Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure.
  • Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure.
  • Construct sub-queries and in-line views within an SQL procedure step.
  • Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.
  • Access Dictionary Tables using the SQL procedure.
Macro Processing
  • Create and use user-defined and automatic macro variables within the SAS Macro Language.
  • Automate programs by defining and calling macros using the SAS Macro Language.
  • Understand the use of macro functions.
  • Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log.
  • Create data-driven programs using SAS Macro Language.
Advanced Programming Techniques
  • Demonstrate the use of advanced data look-up techniques such as array processing, hash objects, formats, and combining/merging data.
  • Reduce computing resource requirements by controlling the space required to store SAS data sets using compression techniques, length statements, or eliminating variables and observations.
  • Develop SAS programs which incorporate data step views and use the FCMP procedure.
  • Perform effective benchmarking by using the appropriate SAS System options and interpreting the resulting resource utilization statistics.
  • Identify appropriate applications for using indexes and create them using the DATA step, the DATASETS procedure, or the SQL procedure.
  • Compare techniques to eliminate duplicate data using the DATA step, the SORT procedure, and the SQL procedure.