Pass the SAS Institute Base Programmer A00-231 Questions and answers with ExamsMirror

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:

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered byDepartment

The following SAS program is submitted:

data WORK.TOTAL;

set WORK.SALARY(keep=Department MonthlyWageRate);

by Department;

if First.Department=1 then Payroll=0;

Payroll+(MonthlyWageRate*12);

if Last.Department=1; run;

Which statement is true? Select one:

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:

Which of the following SAS programs creates a variable named City with a value ofChicago?

Select one:

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 ofVAR20? Enter your numeric answer in the space below. Round your answer to the nearest whole number. Save your program asprogram04.sasincert\programs before continuing with the next project

Scenario:

This project will use data set cert.input08a and cert.input08b. At

any time, you may save your program

as program08 in cert\programs.

Both data sets contain a common numeric variable named ID.

Write a program that will use a SAS DATA Step to:

o Combine data sets cert.input08a and cert.input08b by

matching values of the ID variable.

o Write only observations that are in both data sets to a

new data set named results.match08.

o Write all other non-matching observations from either

data set to a new data set named results.nomatch08.

o Exclude all variables that begin with

"ex" from results.nomatch08.

How many variables (columns) are in results.match08

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?

The following SAS program is submitted:

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

Select one:

Assume thatWork.Ds1andWork.Ds2exist and the following SAS program is submitted:

How many PDF files are created? 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: