SAS certification practice
Free A00-231 Practice Test
10 free A00-231 exam-style questions for SAS 9.4 Base Programming - Performance-Based, with answers, explanations and source references.
Full set: 36 questionsMaster 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:
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: 
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).
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.
