SAS Certified Advanced Programmer for SAS 9 Credential

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.

SAS Advanced Exam A00-212 Requirement Details:

Required Exam to Appear for Advanced SAS Certification

Candidates who earn this credential must have a SAS Certified Base Programmer for SAS 9 credential and then take and pass the 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

SAS Advanced Programming Exam topics Details:

Accessing Data Using SQL
Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure.
  • Use the SELECT statement.
  • Select columns in a table.
  • Create new columns.
  • Sort data.
  • Retrieve rows that satisfy a condition.
  • Validate a query.
  • Join tables – inner joins, full joins, right joins, left joins.
  • Combine tables using set operators – union, outer join, except, intercept.
Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure.
  • Summarize data.
  • Group data.
  • Filter grouped data.
Construct sub-queries and in-line views within an SQL procedure step.
  • Subset data by using non-correlated subqueries (HAVING clause).
  • Subset data by using correlated subqueries.
  • Reference an in-line view with other views or tables (multiple tables).
Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.
  • Use SAS data set options with PROC SQL.
  • Use PROC SQL with the SAS Macro Facility.
  • Create SAS Data sets (tables).
  • Insert rows into tables.
  • Update data values in a table.
  • Delete rows.
  • Alter Columns attributes.
  • Create an index.
  • Delete a table.
Access Dictionary Tables using the SQL procedure.
  • Access SAS system information by using DICTIONARY tables.
  • Use the DESCRIBE TABLE statement.
Macro Processing
Create and use user-defined and automatic macro variables within the SAS Macro Language.
  • Define Macro variables.
  • Use %GLOBAL statement.
  • Use %INPUT statement.
  • Use INTO clause of the SELECT statement in SQL.
  • Use %LOCAL statement.
  • Use the SYMPUT and SYMPUTX routine and SYMPUTN routine in SQL.
  • Use the SYMGET function to return the value of a macro variable to the DATA step during DATA step execution.
Automate programs by defining and calling macros using the SAS Macro Language.
  • Define a macro.
  • Use the %MACRO statement.
  • Insert comments into macros.
  • Pass Information into a macro using parameters.
  • Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements.
Understand the use of macro functions.
  • Use macro character functions.
  • Use macro quoting functions.
  • Use macro evaluation Functions.
  • Use %Symget.
Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log.
  • Use system options to track problems.
  • Trace the flow of execution with MLOGIC.
  • Examine the generated SAS statements with MPRINT.
  • Examine macro variable resolution with SYMBOLGEN.
  • Use the %PUT statement to track problems.
Create data-driven programs using SAS Macro Language.
  • Create macro variables with a list of values.
  • Use indirect reference to macro variables.
  • Generate repetitive macro calls using the %DO loop, macro variable, and the EXECUTE routine.
Advanced Programming Techniques
Demonstrate the use of advanced data look-up techniques such as array processing, hash objects, formats, and merging.
  • Combine data using multiple set statements with KEY= option.
  • Combine data conditionally using multiple set statements.
  • Combine data with Proc SQL
Reduce computing resource requirements by controlling the space required to store SAS data sets.
  • Use compression techniques, RLE (Run-Length Encoding) and RDC (Ross Data Compression).
  • Reduce length of numeric variables.
  • Eliminate variables and observations.
  • Use SAS views.
Use the FCMP procedure to create a user-defined function.
  • Define a SAS function. Example:
    PROC FCMP OUTLIB=libref.data-set.pakage;
    FUNTION function-name(argument-1 <$>,…,argument-m<$>) <$> ;
    Programing statements
    RETURN(expression);
    ENDSUB;
    QUIT;
Perform effective benchmarking.
  • Use the appropriate SAS System options.
  • Interpret the resulting resource utilization statistics for the Z/OS environment and for directory based OS.
Use SAS indexes.
  • Identify appropriate applications for using indexes.
  • Create and delete indexes using the DATA step, the DATASETS procedure, or the SQL procedure.
Compare techniques to eliminate duplicate data.
  • Use the DATA step.
  • Use the SORT procedure.
  • Use the SQL procedure.

How to Prepare for SAS Advanced Certification?

Experience is a critical component to becoming a SAS Certified Professional. These resources are designed to help you prepare.

SAS Advanced Certification Online practice exams
SAS Advanced Certification Questions PDF for A00-212
SAS Advanced Certifications Questions and Answers

SAS Advanced Certification Books:

SAS Certification Prep Guide: Advanced Programming for SAS 9, Fourth Edition

The official guide from the SAS Certification Program that covers all of the objectives tested in the exam. Topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. Updated for V9.4, the content has been enhanced to better prepare students for the exam and now includes a chapter on creating functions with PROC FCMP which is covered in the exam.