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
- Assign a libref with a LIBNAME statement and inspect a library with PROC CONTENTS.
- Concatenate and merge SAS data sets, using the IN= option to see where each observation came from.
- Keep running totals with accumulator variables and BY-group processing.
- Reshape data between long and wide layouts with PROC TRANSPOSE.
- Read the SAS log to locate and correct syntax, logic and data errors.
- Build list and summary reports with PROC PRINT, PROC MEANS and PROC FREQ, then route them through ODS.
Explore related topics
A00-231 exam content
4 domains · 32 topics · 217 of 487 questions are written for A00-231
Access and Create Data Structures47 questions
This domain covers getting data into SAS and storing it in the right place. Candidates create data sets in the DATA step, assign and investigate libraries, import external files and combine data sets.
Skills tested
- Create temporary and permanent SAS data sets from existing data sets.
- Assign a libref with LIBNAME and list a data set's metadata with PROC CONTENTS.
- Import an external file with PROC IMPORT, setting options such as DBMS= and GETNAMES.
- Concatenate data sets, and merge them by a common variable after sorting both.
Questions by topic
- Access External Data with PROC IMPORT5
- Investigate SAS Data Libraries9
- Combine SAS Data Sets16
- Create SAS Data Sets5
- Control Data Processing2
- Create temporary and permanent SAS data sets6
- Access External Data4
Manage Data84 questions
The broadest domain covers the work done inside the DATA step. Candidates filter, sort and create values, use SAS functions, loops and conditional logic, reshape data and set up macro variables.
Skills tested
- Store, convert and display dates with SAS date values, date functions and date formats.
- Choose observations with IF-THEN/ELSE logic and choose variables with KEEP and DROP.
- Total values per group with accumulator variables and FIRST.variable and LAST.variable.
- Clean text with SCAN, SUBSTR and TRIM, and turn text into numbers with the INPUT function.
- Write iterative DO, DO WHILE and DO UNTIL loops that generate or process data.
Questions by topic
- Accumulate Values with BY-Group Processing6
- Use SAS Functions (Character)13
- Restructure Data with PROC TRANSPOSE7
- Conditionally Execute Statements6
- Use Macro Variables8
- Use SAS Functions (Conversion)8
- Process Data with DO LOOPS10
- Accumulate Values6
- Create and Manipulate SAS Date Values8
- Use Assignment Statements4
- Control Data Processing3
- Identify and Resolve Programming Logic Errors1
- Combine SAS Data Sets1
- Sort Observations3
Error Handling34 questions
This domain checks whether a candidate can find out why a program fails or gives a wrong answer. It covers syntax errors reported in the log, logic errors that give wrong results without an error, and errors in the data itself.
Skills tested
- Read error messages in the SAS log and correct the syntax that caused them.
- Track down a logic error, such as an incorrect calculation or statement order.
- Spot invalid data messages and apply data validation techniques to clean the data.
Questions by topic
- Identify and Resolve Programming Logic Errors17
- Recognize and Correct Syntax Errors9
- Examine and Resolve Data Errors8
Generate Reports and Output52 questions
This domain turns data into reports and files that other people use. Candidates print and summarize data, improve the layout with formats, titles and footnotes, and send output to other formats with ODS and PROC EXPORT.
Skills tested
- Produce a detailed list report with PROC PRINT and add totals to it.
- Calculate statistics and frequency tables with PROC MEANS, PROC FREQ and PROC UNIVARIATE.
- Create user-defined formats with PROC FORMAT and apply them with a FORMAT statement.
- Write output to several formats with ODS statements, and export data sets with PROC EXPORT.
Questions by topic
- Generate Output with ODS13
- Enhance Reports with PROC FORMAT7
- Generate List Reports with PROC PRINT6
- Generate Summary Reports with PROC MEANS6
- Export Data with PROC EXPORT4
- Generate Summary Reports7
- Export Data4
- Enhance Reports5
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: at least six months of programming in SAS.
- Recommended: experience with the DATA step and SAS procedures, and an understanding of data manipulation.
- Recommended: basic knowledge of statistics.
About the A00-231 exam
A00-231 is SAS Institute's exam for programmers and analysts who write Base SAS code to read, prepare and report on data. It is a performance-based exam with four domains: accessing and creating data structures, managing data, handling errors, and generating reports and output. Passing earns the SAS Certified Specialist: Base Programming Using SAS 9.4 credential, which has no expiration date.
The PlanetCert practice test gives Manage Data the most questions, from SAS date values and character functions to DO loops and PROC TRANSPOSE. Every answer comes with an explanation that follows the program step by step. This matters most in Error Handling, where one misplaced statement changes the result. Study Mode suits that domain, and flashcard mode suits function names such as SCAN, CATX and COMPRESS. Brainy AI Assistant can explain an unfamiliar log message or why a merge produced more observations than expected.
How to earn the certification
- Earns
- SAS Certified Specialist: Base Programming Using SAS 9.4Specialist
The credential has no expiration date.
- After
- A00-232 SAS Certified Professional: Advanced Programming Using SAS 9.4
The professional-level credential that comes next on the SAS Programming track.
- A00-232 SAS Certified Professional: Advanced Programming Using SAS 9.4
How to prepare for A00-231
- 1
Set up a SAS 9.4 workspace
Work in a SAS 9.4 environment where programs can be written, run and checked in the log. Each topic in the syllabus is easier to remember after changing code and seeing the result.
- 2
Import, combine and reshape real files
Read a CSV file with PROC IMPORT into a permanent library, then concatenate, merge and transpose it. Check each result with PROC CONTENTS and PROC PRINT before going on.
- 3
Give Manage Data the most hours
Manage Data is the broadest domain and has the most questions in the practice test. Write short programs for date values, character functions, DO loops and BY-group totals until each one works without notes.
- 4
Break working programs on purpose
Remove a semicolon, swap two statements or feed in an invalid value, then read what the log says. This is the skill that the Error Handling domain checks.
- 5
Close with timed practice
Take the A00-231 practice test in Study Mode one domain at a time, then once in Timed Mode. Ask Brainy AI Assistant to trace any program whose output was a surprise.
Start a timed A00-231run
Who A00-231 is for
- Data and business analysts who prepare data and build reports in SAS.
- Programmers with some months of SAS experience who want a credential for their Base SAS skills.
- Students and academics who use SAS for coursework or research.
- Professionals moving into SAS programming from another tool or language.
Typical job titles: SAS programmer · Data analyst · Business analyst · Statistical programmer · Reporting analyst
A00-231 glossary
18 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- %LET statement
- A macro statement that creates a macro variable and gives it a value, which the program then uses through an ampersand reference.
- Accumulator variables
- Variables that keep a running total from one observation to the next, such as total sales so far.
- BY-group processing
- Working through sorted data in groups of observations that share the same value of a BY variable, such as all observations for one region.
- CALL SYMPUT
- A DATA step routine that copies a value from the data into a macro variable, for use in later steps of the program.
- DATA step
- The part of a SAS program that builds or changes a data set, processing one observation at a time.
- Date informats
- Instructions that tell SAS how to read a date written as text, such as 15JAN2024, and store it as a SAS date value.
- DO UNTIL loops
- Loops that test their condition at the end of each pass, so their statements always run at least once.
- FIRST. and LAST. variables
- Temporary variables that SAS creates during BY-group processing, set to 1 on the first or the last observation of each group.
- IN= data set option
- An option that creates a temporary variable showing whether a data set added data to the current observation during a merge.
- LIBNAME statement
- A statement that assigns a library reference name (libref) to a storage location, so SAS can read and save data sets there.
- ODS statements
- Statements of the Output Delivery System that send procedure output to destinations such as HTML, PDF or Excel files.
- PROC CONTENTS
- A procedure that describes a data set or a library, listing details such as variable names, types and lengths.
- PROC FORMAT
- A procedure that creates user-defined formats, so that stored codes such as 1 and 2 print as labels such as Yes and No.
- PROC IMPORT
- A procedure that reads an external file, such as a CSV or Excel file, and turns it into a SAS data set.
- PROC MEANS
- A procedure that calculates summary statistics, such as the mean, minimum and maximum, for numeric variables.
- PROC TRANSPOSE
- A procedure that turns variables into observations or observations into variables, to move data between wide and long format.
- SAS date values
- The way SAS stores a date: as the number of days between January 1, 1960 and that date.
- Temporary and permanent SAS data sets
- A temporary data set is stored in the WORK library and is deleted when the session ends. A permanent one is stored in an assigned library and stays.