A00-212: SAS Certified Advanced Programmer for SAS 9

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 A00-212 Exam Summary:

Exam Name	SAS Certified Base Programmer for SAS 9
Exam Code	A00-212
Exam Duration	120 minutes
Exam Questions	60 to 65 multiple-choice and short-answer questions
Passing Score	65%
Exam Price	$180 (USD)
Training	SAS Programming 3: Advanced Techniques and Efficiencies SAS Macro Language 1: Essentials SAS SQL 1: Essentials
Books	SAS® Certification Prep Guide: Advanced Programming for SAS 9
Sample Questions	Sample Question Set-1 Sample Question Set-2
Practice Exam	SAS Advanced Programmer Certification Practice Exam

SAS A00-212 Exam Topics:

Objective	Details
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 merging. - Reduce computing resource requirements by controlling the space required to store SAS data sets. - Use the FCMP procedure to create a user-defined function. - Perform effective benchmarking. - Use SAS indexes. - Compare techniques to eliminate duplicate data.