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

Page: 1 / 14
Total 36 questions
Question 1

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 181 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 2

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.



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 3

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:



Answer : A


Question 4

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 5

The following SAS program is submitted:

Which output is correct?



Answer : B


Question 6

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:



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