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

SIMULATION

Scenario:

This project will use data set cert.input27. At any time, you may

save your program as program27 in cert\programs. You will use

this program in the next project.

Write a SAS program that will:

o Create output data set results.output27a as a subset

of cert.input27 where the country variable's value is

"US" (any variation of case, such as US or us).

o Sort results.output27a:

" first by the variable state in ascending order

" then by Postal_Code in descending order

" and finally by employee_ID in ascending order.

Run the program and use the results to answer the question below.

What is the value of Employee_ID for observation 100 in results.output27a?

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)

The following SAS program is submitted:

Why does the program produce an error? Select one:

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:

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

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: