Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.

AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by SAS Institute
Exam Format
Registration
Validity
Skills this practice test covers
- Join tables in PROC SQL with inner, left, right and full joins, and stack results with set operators.
- Summarize groups with GROUP BY and HAVING, and reuse new columns with the CALCULATED keyword.
- Create macro variables with the INTO clause or SYMPUTX, and control whether they are global or local.
- Debug macro code by reading the MPRINT, MLOGIC and SYMBOLGEN output in the log.
- Look up and sort data with hash objects and hash iterator objects.
- Build custom formats with the PICTURE statement and custom functions with PROC FCMP.
Explore related topics
A00-232 exam content
3 domains · 47 topics · 317 of 326 questions sorted by domain
Accessing Data Using SQL35%95 questions
This domain covers PROC SQL, from simple queries to SAS-specific features. Candidates produce detail and summary reports from one table, from joins or with set operators, nest subqueries and in-line views, and query metadata through DICTIONARY tables.
Skills tested
- Join tables with inner, left, right and full joins, and use COALESCE to merge the key columns of a full join.
- Combine query results with UNION, OUTER UNION, EXCEPT and INTERSECT.
- Summarize data with AVG, COUNT, MAX, MIN and SUM, and filter the groups with a HAVING clause.
- Subset data with non-correlated subqueries, and reference an in-line view together with other tables.
- Control output with the INOBS=, OUTOBS=, NOPRINT and NUMBER options and data set options such as KEEP= and RENAME=.
Questions by topic
- Join tables - inner joins, full joins (coalesce function), right joins, left joins.9
- Filter grouped data using HAVING clause.8
- Use PROC SQL invocation options (INOBS=, OUTOBS=, NOPRINT, NUMBER)8
- Use the CALCULATED keyword.6
- Combine tables using set operators - union, outer union, except, intersect.15
- Subset data by using non-correlated subqueries.6
- This question tests advanced DATA step concepts often related to data access, fitting the spirit of the domain.2
- Eliminate duplicate values with the DISTINCT keyword.6
- Reference an in-line view with other views or tables (multiple tables).7
- Sort data with an ORDER BY clause.5
- Assign an alias with the AS keyword.5
- Construct sub-queries and in-line views within an SQL procedure step.7
- Access SAS system information by using DICTIONARY tables (members, tables, columns)5
- Group data using GROUP BY clause.3
- Retrieve rows that satisfy a condition with a WHERE clause.3
Macro Processing35%112 questions
The SAS Macro Language generates SAS code before that code runs. Candidates create macro variables, define and call macros with and without parameters, use macro functions, debug with system options, and build data-driven programs.
Skills tested
- Create macro variables with the INTO clause of a SELECT statement or the SYMPUTX routine in a DATA step.
- Control scope with the %GLOBAL and %LOCAL statements and the SYMPUTX scope parameter.
- Generate code conditionally with %IF-%THEN-%ELSE and iterative %DO statements.
- Treat special characters as text with %STR and %NRSTR, and run DATA step functions through %SYSFUNC.
- Store macros permanently with the SAS AUTOCALL facility and call them from later programs.
Questions by topic
- Create a series of macro variables.6
- Examine macro variable resolution with the SYMBOLGEN option.6
- Use macro evaluation functions. (%SYSEVALF)8
- Use macro quoting functions. (%NRSTR, %STR)12
- Create data-driven programs using SAS Macro Language.7
- Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements10
- Use %SYSFUNC to execute DATA step functions within the SAS Macro Language.6
- Use the SAS AUTOCALL facility to permanently store and call macros.7
- Use macro functions. (%SCAN, %SUBSTR, %UPCASE)8
- Control variable scope with: %GLOBAL statement, %LOCAL statement7
- Generate repetitive macro calls.5
- Examine the generated SAS statements with the MPRINT option.6
- Control variable scope with: SYMPUTX scope parameter6
- Use indirect reference to macro variables. (&&, etc.)7
- Trace the flow of execution with the MLOGIC option.5
- Debug Macros.6
Advanced Techniques30%110 questions
This domain goes past the base DATA step. Candidates process data with one- and two-dimensional arrays and with hash objects, build templates and functions with the FORMAT and FCMP procedures, and use advanced functions such as LAG and the PRX functions.
Skills tested
- Define temporary arrays, size them with the DIM function and load initial values from a SAS data set.
- Declare hash and hash iterator objects and use the definekey(), definedata(), definedone(), find(), add() and output() methods.
- Write a PICTURE statement with directives for dates and times, or digit selectors for numbers.
- Create character and numeric functions with PROC FCMP and make them available with the CMPLIB= option.
- Find, count and match text with FINDC, FINDW, COUNTW, PRXPARSE, PRXMATCH and PRXCHANGE.
Questions by topic
- Use hash objects as lookup tables.11
- Regular expression pattern matching with PRX functions12
- Create custom functions with the FCMP procedure6
- Retrieve previous values with the LAG function.8
- Process data using 1 and 2 dimensional arrays.10
- Specify a template using the PICTURE statement within the FORMAT Procedure6
- Use hash object methods10
- Define arrays as temporary arrays.6
- Counting strings or words with the COUNT/COUNTC/COUNTW functions.6
- Use hash iterator object methods7
- Use custom functions with the global option CMPLIB=.6
- Load initial values for an array from a SAS data set.5
- Specify the array dimension with the DIM function.5
- Declare hash and hash iterator objects6
- Use hash objects to create sorted data sets.4
- This question tests advanced DATA step concepts often related to data access, fitting the spirit of the domain.2
Requirements
- Required: a current SAS base credential, from SAS 9.4 Base Programming or the older SAS Base Programming for SAS 9 exam.
- Recommended: practical SAS programming with SQL queries, macro programming and advanced DATA step techniques.
About the A00-232 exam
A00-232 is the exam for the SAS Certified Professional: Advanced Programming Using SAS 9.4 credential, the step after SAS base programming. It is performance-based: candidates write working programs with PROC SQL, the SAS Macro Language, and DATA steps that use arrays and hash objects. The exam mixes programming projects, which a SAS scoring macro assesses, with standard questions. SAS awards the credential to candidates who pass and also hold a current SAS base programming credential.
The PlanetCert practice test covers the three domains in close to equal parts, as the exam does. Every answer has an explanation, which matters most where the result of the code is easy to misjudge, such as how an indirect reference with && resolves or which rows a full join keeps. Study Mode suits macro quoting and hash object methods, where small details in the code decide the answer. Brainy AI Assistant can trace the code a macro generates, or explain how a hash iterator moves through the keys. Because the exam itself asks for working programs, each topic is worth coding in SAS after its questions.
How to earn the certification
- Earns
- SAS Certified Professional: Advanced Programming Using SAS 9.4Professional
The credential does not expire.
- Before
- A00-231 SAS 9.4 Base Programming
Required. A current base credential, such as the one this exam earns, is part of earning the Advanced credential.
- A00-231 SAS 9.4 Base Programming
How to prepare for A00-232
- 1
Code every objective in SAS
Work through SAS's exam content guide one objective at a time, and write a short program for each. A SAS scoring macro assesses the exam's programming projects, so practise until each program runs cleanly.
- 2
Solve one report three ways
Build the same report with a join, with a subquery and with an in-line view, then compare the output. Check where a full join needs COALESCE to fill the key column.
- 3
Read the macro log line by line
Turn on MPRINT, MLOGIC and SYMBOLGEN for every macro written during study. Then build one data-driven macro that reads a DICTIONARY table and generates a repetitive macro call for each row.
- 4
Load a lookup into a hash
Load a small lookup table into a hash object, search it with find() and write a sorted data set with output(). Then step through it with a hash iterator in forward and reverse key order.
- 5
Finish under the clock
Take the A00-232 practice test in Timed Mode once all three domains feel solid. Ask Brainy AI Assistant to walk through each missed question, then code that case in SAS to see the result.
Start a timed A00-232run
SAS's training for this exam includes SAS SQL 1: Essentials, SAS Macro Language 1: Essentials and SAS Programming 3: Advanced Techniques, one course for each domain. SAS Press also publishes the SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4.
Who A00-232 is for
- SAS programmers who hold a base credential and now write PROC SQL and macro code.
- Statistical programmers who automate repeated reports with data-driven macros.
- Data analysts and BI developers who query and summarize SAS data with SQL.
- Data engineers who reshape large SAS data sets with arrays and hash objects.
Typical job titles: SAS programmer · Statistical programmer · Data analyst · BI developer · Data engineer
A00-232 glossary
19 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- %SYSFUNC
- A macro function that runs a DATA step function inside the SAS Macro Language.
- CALCULATED keyword
- A PROC SQL keyword that lets a clause refer to a column computed earlier in the same SELECT statement.
- COALESCE
- A function that returns the first non-missing value among its arguments. In a full join, it combines the key columns of both tables into one.
- DICTIONARY tables
- Read-only tables that PROC SQL can query for information about libraries, data sets and columns.
- Hash iterator object
- An object that moves through the entries of a hash object in key order, forward or backward, with first(), next(), last() and prev().
- Hash objects
- In-memory lookup tables that a DATA step declares, fills with keys and data, and searches by key.
- In-line view
- A query placed in the FROM clause of another query, where it acts as a temporary table.
- Indirect reference
- A macro variable reference with several ampersands, such as &&, that resolves in steps to the value of another macro variable.
- Macro quoting functions
- Functions such as %STR and %NRSTR that make the macro processor treat special characters as plain text.
- MPRINT
- A system option that writes the SAS statements a macro generates to the log.
- Non-correlated subqueries
- Subqueries that run on their own, without values from the outer query, and pass their result to it.
- PICTURE statement
- A PROC FORMAT statement that defines a template for displaying numbers, dates and times.
- PROC FCMP
- The SAS procedure that creates custom functions, which programs then find through the CMPLIB= option.
- PROC SQL
- The SAS procedure that runs SQL queries to select, join and summarize data and to create tables.
- SAS AUTOCALL facility
- A SAS feature that stores macros permanently in a library, so programs can call them without defining them first.
- Set operators
- Operators such as UNION, OUTER UNION, EXCEPT and INTERSECT that combine the rows of two query results.
- SYMBOLGEN
- A system option that shows in the log how each macro variable reference resolves.
- SYMPUTX
- A DATA step routine that assigns a value to a macro variable and can set whether that variable is global or local.
- Temporary arrays
- Arrays whose values exist only while the DATA step runs and are not written to the output data set.