A00-231

SAS Base Programming A00-231 practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 135-minute limit. The pass mark is 73%. Results are split across the 4 exam domains.

Exam at a glance

A00-231 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 135 minutes
Pass mark 73%
Question types Single answer and multiple answer (22 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official SAS exam page for the current exam format before you book.

Domains and weights

A00-231 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Access and Create Data Structures 24% 70
Manage Data 40% 116
Error Handling 18% 52
Generate Reports and Output 18% 52

Sample questions

Question 1 of 3

A comma-delimited file contains the line 101,"Smith, Ann",,45. The programmer wants SAS to keep "Smith, Ann" as one value without quotation marks and to read the empty field between the two consecutive commas as a missing value. Which INFILE option should be added?

  1. A DSD (correct answer)
  2. B TRUNCOVER
  3. C MISSOVER
  4. D DLM=','
Why: DSD treats consecutive delimiters as a missing value, removes quotation marks from quoted values, ignores delimiters inside quotes, and uses a comma as the default delimiter. DLM=',' alone treats consecutive commas as a single delimiter and splits the quoted name. MISSOVER and TRUNCOVER control what happens when a record is shorter than the INPUT statement expects; they do not handle quotes or empty fields.

Question 2 of 3

PROC IMPORT reads a CSV file in which some city names after row 500 are longer than any earlier value, and those names are truncated in the output data set. Which statement in the PROC IMPORT step prevents this?

  1. A datarow=1;
  2. B getnames=no;
  3. C replace;
  4. D guessingrows=max; (correct answer)
Why: PROC IMPORT sets column types and lengths from a sample of rows (20 by default), so values longer than anything in the sample are truncated; GUESSINGROWS=MAX scans every row before setting lengths. GETNAMES=NO reads the header row as data, DATAROW=1 also starts reading at the header line, and REPLACE only allows an existing output data set to be overwritten.

Question 3 of 3

A programmer wants to keep only the first order for each customer_id in work.orders and save the removed orders in a separate data set. Which step does this?

  1. A proc sort data=orders out=first nodupkey dupout=extra; by customer_id; run; (correct answer)
  2. B proc sort data=orders out=first nodupkey; by _all_; run;
  3. C proc sort data=orders out=first dupout=extra; by customer_id _all_; run;
  4. D proc sort data=orders out=first noduprecs dupout=extra; by customer_id; run;
Why: NODUPKEY keeps only the first observation for each unique BY value, and DUPOUT= writes the removed observations to another data set. NODUPRECS removes only observations that are identical in every variable to the previous one, DUPOUT= has no effect without NODUPKEY or NODUPRECS, and BY ALL with NODUPKEY removes only complete duplicates instead of extra orders per customer.

What your score report looks like

Example attempt, A00-231 practice test 3

78%

Passed
Pass mark 73%

Score by exam domain
DomainWeightYour score%
Access and Create Data Structures 24%
88
Manage Data 40%
81
Error Handling 18%
76
Generate Reports and Output 18%
58

Study next: Generate Reports and Output. It is below the pass mark and carries 18% of the exam.

Domains and pass mark from our A00-231 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Manage Data and Access and Create Data Structures, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the A00-231 practice exams

Are these real A00-231 exam questions?
No. We write every question ourselves and map it to the published A00-231 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with SAS. A00-231 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
A00-232SAS Advanced Programming A00-232 SAS Professional 300 120 $14.99
DP-900Azure Data Fundamentals DP-900 Microsoft Foundational 225 45 $9.99
SPLK-1001Splunk Core Certified User (SPLK-1001) Splunk Foundational 300 60 $9.99
1Z0-071Oracle Database SQL 1Z0-071 Oracle Associate 315 120 $12.99
1Z0-082Oracle Database Admin I 1Z0-082 Oracle Associate 300 100 $12.99
COF-C03SnowPro Core COF-C03 Snowflake Associate 300 70 $12.99