SAS A00-231 Exam Questions

The following SAS program is submitted:

Why does the program produce an error? 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

The following SAS program is submitted:

data work.test;

type='SQL';

if type='SAS' then description='SAS Program';

else description='other'; length description 8;

run;

What occurs when the program is submitted?

Select one:

The following SAS program is submitted:

proc means data=work.schools median;

run;

Assume thatWork.Schoolshas two numeric variables and the following PROC MEANS report is produced:

Which of the following SAS statements completes the program and creates the desired report? 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: