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

Which statement about SAS libraries is true? Select one:

SIMULATION

Scenario: This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:

Step 1:
create a temporary data set, cleandata36. In this data set, convert all case. Then keep only observations with group equal to 'A' or 'B'.

Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.

Step 3:
Create results.output36 from cleandata36 Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the
respectivegroup(A,B) calculated in step 2

How many observations are inresults.output36?

Variable Name would have a format of $CHAR15. in the new data set Work. Both. The LENGTH statement only gives the variable Name a predefined maximum length. The correct answer is: $CHAR15 Given the SAS data set WORK.ONE: X Y Z

- - --
1 A 27 1 A 33 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91

The following SAS program is submitted:
data WORK.TWO;
set WORK.ONE;
by X Y;
if First.Y; run; proc print data=WORK.TWO noobs;
run;

Which report is produced?

Select one:

SIMULATION

Scenario: following criteria: Continuing with the previous program (program27), add a PROC SORT step that satisfies the 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: 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: