SAS Institute A00-231 Practice Exams
Last updated on Oct 21,2026- Exam Code: A00-231
- Exam Name: SAS 9.4 Base Programming -- Performance-based exam
- Certification Provider: SAS Institute
- Latest update: Oct 21,2026
SIMULATION
Scenario:
Open the existing program, program44.sasfrom folder certerrors. At any time, you may save your corrected program asprogram44incertprograms.
This program is intended to:
o Create a new data set using thecert.input44set as input
o Drop variables:bp_status, weight_status, andsmoking _status.
o Create a new column,chol_status, based on the following values of cholesterol:
less than 200: "Safe"
200-239: "High – Borderline"
240 and higher: "High" oShould not calculatechol_statusfor missing cholesterol values There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results
to answer the next 3 questions.
How many variables are in thework. outdata set? Enter your numeric answer in the space below:
Explanation:
The following SAS program is submitted:
Which output is correct?
- A . yearamount i qtr 2017 33637.50 65
- B . yearamount i qtr 2016 33637.50 65
- C . yearamount i qtr 2016 33637.50 55
- D . yearamount i qtr 2016 33637.50 64
SIMULATION
Scenario:
This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in certprograms.
Both data sets contain a common numeric variable named ID.
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.
How many variables (columns) are in _______________ results.nomatch08
Enter your numeric answer in the space below:
Save your program as ______________ program08.sas in folder cert programs before continuing with the next project.
Explanation:
SAS code that could be used to solve this project:
Proc
sort data=cert.input08a out=work.input08a;
by ID;
run;
proc sort data=cert.input08b out=work.input08b;
by ID;
run;
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 5
SIMULATION
Scenario:
Open the existing program, program48.sasfrom folder certerrors. At any time, you may save your corrected program asprogram48incertprograms.
This program is intended to:
O Create 3 groups for C var: A-G is Group=1; H-N is Group=2; O-Z is Group=3.
O All variations of the variable should be in the same group, i.e. "A" and "a" should be in Group=1.
O Calculate the average of X and Y by Group.
There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results to answer the next 2 questions.
What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number.
Enter your numeric answer in the space below:
Explanation:
Assume thatWork.Ds1andWork.Ds2exist and the following SAS program is submitted:
How many PDF files are created? Select one:
- A . 1 PDF file with all the output combined
- B . 2 PDF files — one file for each data set used
- C . 2 PDF files — one for the PRINT output and one for the FREQ output
- D . 3 PDF files — one per procedure request
Scenario:
The following code is submitted: data WORK.FINAL_EMPS; set WORK.EMPLOYEE WORK.NEW_EMPS; run; proc print data=WORK.FINAL_EMPS; title ‘The RESULTS Data Set’; run; What is the resulting data set?
- A . The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Mary27
- B . The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Maryengineering27
- C . The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30
- D . The RESULTS Data Set nameDeptage Mary27 TomEngineering36 SallyHR42 Davidengineering30
SIMULATION
Scenario:
This project will use data set cert.input27. At any time, you may save your program as program27 in certprograms. You will use this program in the next project.
Write a SAS program that will:
o Create output data set results.output27a as a subset
of cert.input27 where the country variable’s value is
"US" (any variation of case, such as US or us).
o Sort results.output27a:
" first by the variable state in ascending order
" then by Postal_Code in descending order
" and finally by employee_ID in ascending order.
Run the program and use the results to answer the question below.
What is the value of Employee_ID for observation 100 in results.output27a?
Explanation:
proc sort data=cert.input27
out=results.output27a(where=(upcase (country)=’US’));
by state descending Postal_Code employee_ID;
run;
proc print data=results.output27a (firstobs=100 obs=100);
var employee_ID;
run:
SIMULATION
Scenario:
This project will use data set cert.input12. At any time, you may save your program as program12 in certprograms.
cert.input12 contains a single observation with two variables:
o salary o year
Write a SAS program that will:
o Create an output data set results.output12.
o Read cert.input12 as input.
o Increase the salary variable by 5.65% annually until it is greater than $500,000.
o Increment the year variable by 1 with each annual increase.
o Create an output data set results.output12 that has one observation for each value of year. Each observation should have a year and salary variable.
What is the value of year when the above salary occurs? Enter your numeric answer in the space below.
Explanation:
data results.output12;
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;
SIMULATION
Scenario:
This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in certprograms.
Both data sets contain a common numeric variable named ID.
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.
How many variables (columns) are in results.match08
Explanation:
proc sort data=cert.input08b out=work.input08b;
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
SAS code that could be used to solve this project:
proc
sort data=cert.input08a out=work.input08a;
by ID;
run:
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 117
A PROC PRINT report was created with the following title:
Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles?
- A . title "Distribution by Make";
- B . title "Asia Sports Vehicle Summary"; title "Distribution by Make";
- C . title "Asia Sports Vehicle Summary"; title2 "Distribution by Make";
- D . title "Asia Sports Vehicle Summary"; subtitle "Distribution by Make";