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.

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?

A PROC PRINT report was created with the following title:

Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles?

Select one:

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.nomatch08

Enter your numeric answer in the space below:

Save your program as ______________ program08.sas in folder cert programs

before continuing with the next project.

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:

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

Select one:

The following SAS program is submitted:

Why does the program produce an error? Select one: