SAS 9.4 Base Programming - Performance-Based A00-231 Exam Questions

Page: 1 / 14
Total 36 questions
Question 1

What is the format for the variableNamein the data setBoth? Select one:



Answer : D


Question 2

The following SAS program is submitted:

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

Select one:



Answer : D


Question 3

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?



Answer : A

proc sort data=cert.input27 out=results.output27b nodupkey;

by descending postal_code;

run;

proc print data=results.output27b (firstobs=98 obs=181);

var employee_ID;

run:


Question 4

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 maximum salary hat is less than $500,000? Enter your numeric answer in the space below (Round your answer to the nearest integer)



Answer : A

data results.output12;

set cert.input12;

do until (salary gt 500000);

salary=salary*1.0565;

year+1;

output;

end;

run;

proc print data=results.output 12;

run;


Question 5

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:



Answer : A

SAS code that could be used to solve this project:

data results.output04;

set cert.input04;

var3=round(var1,1)*round(var2,1);

var20=sum(of var12-var19);

run;

proc print data=results.output04 (obs=16 firstobs=16);

var var3 var20;

run;

The 'obs' option controls the last observation SAS processes. If you set obs=16, SAS would read and process only up to the 16th observation in the data set.

The 'firstobs' option controls the starting observation. If you set firstobs=16, SAS would start reading and processing from the 16th observation.


Question 6

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

What is the MEAN Kilograms value for group='A' in the results.output36 data set?



Answer : A


Question 7

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?



Answer : A


Page:    1 / 14   
Total 36 questions