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

SIMULATION

Scenario: Open the existing program, program44.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram44incert\programs. 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:

Select one:

The following SAS program is submitted:



What are the values for x and y in the output data set?

Which statement about SAS libraries is true? Select one:

Given the following SAS data set WORK.CLASS: Name Gender Age Anna F 23 Ben M 25 Bob M 21 Brian M 27 Edward M 26 Emma F 32 Joe M 34 Sam F 32 Tom M 24 The following program is submitted: data WORK.MALES WORK.FEMALES(drop=age); set WORK.CLASS; drop gender; if Gender="M" then output WORK.MALES; else if Gender="F" then output WORK.FEMALES; run; How many variables are in the data set WORK.MALES?

Select one:

The following SAS program is submitted:
proc means data=work.schools median;
Assume thatWork.Schoolshas two numeric variables and the following PROC MEANS report is



run;
produced: Which of the following SAS statements completes the program and creates the desired report? Select one: