SAS Logo

Worldwide Sites

Worldwide Contacts

If you don't find your country/region in the list, see our worldwide contacts list.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Videos
Merchandise
Brand
PartnerNet

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 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

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.

Exam Preparation

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

Training

Get training from SAS experts. To view training options in your country, choose your location above.

Advanced SAS Programmer 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.

Practice

View the sample questions for this exam.
Practice your skills with the SAS Certification Practice Exam: Advanced Programming for SAS 9.

More information:

Contact the SAS Global Certification Program at certification@sas.com or 800-727-0025.

Back to Top