SAS Certified Specialist Base Programming Certification (A00-231) - SASI

Exam Questions

94%

Students found the real exam almost the same

1,057

Students passed this exam after ExamsQA Prep

95.1%

Average score during Real Exams at the Testing Centre

Browse 33 Questions
💡

Browse at least 50% questions to maximize your chances of passing

Free Preview Questions

Sample A00-231 Exam Questions & Explanations

Practice with real question formats, multiple choice options, and detailed answer explanations for SASI A00-231.

Question #1 Verified Q&A
SIMULATION<br />
<br />
Scenario: This project will use data setcert.input04. At any time, you may save your program asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.<br />
<br />
In this program, complete the following mathematical actions, in the following order: Round VAR1 and VAR2 to the nearest integer values. Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3. Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.<br />
<br />
For observation 16, what is the value ofVAR3? Enter your numeric answer in the space below:
Explanation:
SAS code that could be used to solve this project:<br />
data results.output04;<br />
set cert.input04;<br />
var3=round(var1,1)*round(var2,1);<br />
var20=sum(of var12-var19);<br />
run;<br />
proc print data=results.output04 (obs=16 firstobs=16);<br />
var var3 var20;<br />
run;<br />
The 'obs' option controls the last observation SAS processes. If you set obs=16, SAS would read and process only up to the 16th observation in the data set. The 'firstobs' option controls the starting observation. If you set firstobs=16, SAS would start reading and processing from the 16th observation.
Question #2 Verified Q&A
SIMULATION<br />
<br />
Scenario: This project will use data setcert.input04. At any time, you may save your program asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.<br />
<br />
In this program, complete the following mathematical actions, in the following order: Round VAR1 and VAR2 to the nearest integer values. Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3. Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.<br />
For observation 16, what is the value ofVAR20? Enter your numeric answer in the space below.<br />
Round your answer to the nearest whole number. Save your program asprogram04.sasincert\programs before continuing with the next project
Explanation:
SAS code that could be used to solve this project:<br />
data results.output04;<br />
set cert.input04;<br />
var3=round(var1,1)*round(var2,1);<br />
var20=sum(of var12-var19);<br />
run;<br />
proc print data=results.output04 (obs=16 firstobs=16);<br />
var var3 var20;<br />
run;<br />
If you got this question wrong because you didn't round to the nearest whole number, please know<br />
that the actual exam will restrict you to entering only a whole number to prevent this from occurring. The correct answer is: 3175
Question #3 Verified Q&A
SIMULATION This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in cert\programs. Both data sets contain a common numeric variable named ID.<br />
<br />
Write a program that will use a SAS DATA Step to: o Combine data sets cert.input08a and cert.input08b by matching values of the ID variable. o Write only observations that are in both data sets to a new data set named results.match08. o Write all other non-matching observations from either data set to a new data set named results.nomatch08. o Exclude all variables that begin with "ex" from results.nomatch08.<br />
<br />
How many observations (rows) are inresults.match08?<br />
<br />
Enter your numeric answer in the space below:
Explanation:
SAS code that could be used to solve this project:<br />
proc sort data=cert.input08a out=work.input08a;<br />
by ID;<br />
run;<br />
proc sort data=cert.input08b out=work.input08b;<br />
by ID;<br />
run;<br />
data results.match08 results.nomatch08 (drop=ex: );<br />
merge work.input08a (in=a) work.input08b (in=b);<br />
by ID;<br />
if a and b then output results.match08;<br />
else output results.nomatch08;<br />
run;<br />
proc contents data=results.match08;<br />
run:<br />
proc contents data=results.nomatch08;<br />
run;<br />
The correct answer is: 1200
Question #4 Verified Q&A
SIMULATION<br />
<br />
Scenario: This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in cert\programs. Both data sets contain a common numeric variable named ID.<br />
<br />
Write a program that will use a SAS DATA Step to: o Combine data sets cert.input08a and cert.input08b by matching values of the ID variable. o Write only observations that are in both data sets to a new data set named results.match08. o Write all other non-matching observations from either data set to a new data set named results.nomatch08. o Exclude all variables that begin with "ex" from results.nomatch08.<br />
<br />
How many variables (columns) are in results.match08
Explanation:
proc sort data=cert.input08b out=work.input08b;<br />
by ID;<br />
run:<br />
data results.match08 results.nomatch08 (drop=ex: );<br />
merge work.input08a (in=a) work.input08b (in=b);<br />
by ID;<br />
if a and b then output results.match08;<br />
else output results.nomatch08;<br />
run;<br />
proc contents data=results.match08;<br />
<br />
SAS code that could be used to solve this project: proc<br />
sort data=cert.input08a out=work.input08a;<br />
by ID;<br />
run:<br />
run;<br />
proc contents data=results.nomatch08;<br />
run;<br />
The correct answer is: 117
Question #5 Verified Q&A
SIMULATION<br />
<br />
Scenario: This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in cert\programs. Both data sets contain a common numeric variable named ID.<br />
<br />
Write a program that will use a SAS DATA Step to: o Combine data sets cert.input08a and cert.input08b by matching values of the ID variable. o Write only observations that are in both data sets to a new data set named results.match08. o Write all other non-matching observations from either data set to a new data set named results.nomatch08. o Exclude all variables that begin with "ex" from results.nomatch08.<br />
<br />
How many observations (rows) are inresults.nomatch08?
Explanation:
proc sort data=cert.input08b out=work.input08b;<br />
by ID;<br />
run:<br />
<br />
SAS code that could be used to solve this project:<br />
proc sort data=cert.input08a out=work.input08a;<br />
by ID;<br />
run:<br />
data results.match08 results.nomatch08 (drop=ex: );<br />
merge work.input08a (in=a) work.input08b (in=b);<br />
by ID;<br />
if a and b then output results.match08;<br />
else output results.nomatch08;<br />
run;<br />
proc contents data=results.match08;<br />
run;<br />
proc contents data=results.nomatch08;<br />
run;<br />
The correct answer is: 2

Want to practice all 33 questions?

Practice under real exam conditions with instant grading, timed simulations, and community insights.

Start Full A00-231 Practice Test

Frequently Asked Questions

Common questions about the SASI A00-231 certification practice test

How many questions are in the SASI A00-231 practice exam on ExamsQA?
Our A00-231 (SAS Certified Specialist Base Programming Certification) practice question bank currently includes 33 verified questions with comprehensive explanations.
Are the A00-231 exam practice questions up to date for 2026?
Yes, all SASI A00-231 practice questions are regularly updated and verified against current exam objectives.
Will the A00-231 practice questions help me pass on my first attempt?
The A00-231 (SAS Certified Specialist Base Programming Certification) question bank is built to mirror the real exam's format and topics, with detailed explanations for every answer so you understand the reasoning — not just memorize responses.
Is there a free demo available for A00-231 SAS Certified Specialist Base Programming Certification?
Yes, ExamsQA offers free demo questions for the A00-231 exam so you can test the interface and question quality before purchasing full access.