SAS certification practice
A00-231 Practice Questions
Try 10 free A00-231 exam-style questions for SAS 9.4 Base Programming - Performance-Based. Check each answer and review the explanation and source references.
- Exam code
- A00-231
- Provider
- SAS
- Free questions
- 10
- Full set
- 36 questions
- Last update check
Master the A00-231 exam and validate your analytics skills with Cert Mage’s trusted preparation resources. We have meticulously developed an A00-231 exam simulator that allows you to practice in a distraction-free, highly simulated testing environment. Inside our extensive question bank, you will find scenarios that directly mirror the live test. Start by reviewing our complimentary A00-231 sample questions to establish your baseline. Then, leverage our full suite of A00-231 practice questions and exact exam questions to confidently secure your new certification.
SIMULATION
Scenario:
This project will use data set cert.input27. At any time, you may
save your program as program27 in cert\programs. 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?
SIMULATION
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.
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.
For observation 16, what is the value ofVAR3? Enter your numeric answer in the space below:
Given the following SAS data set WORK.TOYS:
Product Group Price
--------- ----------- -----
Cards Indoors 9.99
Marbles Indoors 8.99
Drum Instruments 12.99
Hula-Hoop Outdoors 12.99
Ball Outdoors 8.49
The following SAS program is submitted:
data WORK.GROUPS;
set WORK.TOYS;
if Group="Outdoors" then Price_Gp="C";
if Price ge 12.99 then Price_Gp="A";
else if Price ge 8.99 then Price_Gp="B";
run;
What will be the value of Price_Gp for Hula-Hoop and Ball? Select one:
Assume that Sasuser.One does not exist and that the following SAS program is submitted at the
beginning of a new SAS session:
data sasuser.one;
x=1;
y=27;
output one; run;
Select one:
SIMULATION
Scenario:
Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your
corrected program asprogram48incert\programs. 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:
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?
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?SIMULATION
Scenario:
Continuing with the previous program (program27), add a PROC SORT step that satisfies the
following criteria:
o Creates the output dataset results.output27b
o Sorts the observations by order.
o Removes duplicate values of the first occurrence found during the sort.
What is the value of Employee_ID for observation 98 inresults.output27b?
SIMULATION
Scenario:
This project will use data set cert.input12. At any time, you may
save your program as program12 in cert\programs.
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.
SIMULATION
Scenario:
This project will use data set cert.input13. At any time, you may
save your program as program13 in cert\programs.
This data set contains 1001 observations and 2 variables:
o Date1, a numeric variable representing an unformatted
SAS date value. Example: 12001.
o Charnum, a character variable representing a monetary
amount. Example: $50,000.
Write a SAS program that will:
o Save the new data set as results.output13.
o Create a new variable Chdate that converts
the datel variable to a character variable that is in the
format ddmonyyyy, such as 11NOV1992.
o Create a new variable num1 that converts
the Charnum variable to a numeric variable.
What is the average (mean) of the num1 variable for the entire data set?
Enter your numeric answer in the space below (Round your answer to the nearest
integer).
The variable Name in the data set Employeehas a $CHAR10. format. The variable Name in the data
set Sales has a $CHAR15. format. The following SAS program is submitted:
data both;
length name $ 20;
merge sales employee;
by id;
run;
What is the format for the variable Name in the data set Both?
Select one:
Question 1 of 10
Source context
How this practice set is maintained
Maintained by the CertMage content team, this page loads questions from the exam dataset connected to its preparation resource. When an answer includes a supporting reference, it is shown with that answer so you can review the underlying vendor documentation.
Certification objectives, interfaces, and vendor services can change. Verify important details against the provider's current exam guide and documentation before your exam.