Online A00-231 Exam Dumps Help You Build Confidence

1. The following SAS program is submitted:

proc means data=work.schools median;



run;

Assume thatWork.Schoolshas two numeric variables and the following PROC MEANS report is produced:





Which of the following SAS statements completes the program and creates the desired report? Select one:

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

3. SIMULATION

Scenario:

Open the existing program, program48.sasfrom folder certerrors. At any time, you may save your corrected program asprogram48incertprograms.

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:

4. 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?

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

Select one:

6. 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?

7. SIMULATION

Scenario:

Open the existing program, program44.sasfrom folder certerrors. At any time, you may save your corrected program asprogram44incertprograms.

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:

8. SIMULATION

Scenario:

This project will use data set cert.input13. At any time, you may save your program as program13 in certprograms.

This data set contains 1001 observations and 2 variables:

o Date1, a numeric variable representing an unformatted SAS date value. Example: 12001.

o Charnum, a character variable representing a monetary

amount. Example: $50,000.

Write a SAS program that will:

o Save the new data set as results.output13.

o Create a new variable Chdate that converts the datel variable to a character variable that is in the format ddmonyyyy, such as 11NOV1992.

o Create a new variable num1 that converts the Charnum variable to a numeric variable.

What is the average (mean) of the num1 variable for the entire data set?

Enter your numeric answer in the space below (Round your answer to the nearest integer).

9. 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:

10. SIMULATION

Scenario:

This project will use data set cert.input13. At any time, you may save your program as program13 in certprograms.

This data set contains 1001 observations and 2 variables:

o Date1, a numeric variable representing an unformatted SAS date value. Example: 12001.

o Charnum, a character variable representing a monetary amount. Example: $50,000.

Write a SAS program that will:

o Save the new data set as results.output13.

o Create a new variable Chdate that converts

the datel variable to a character variable that is in the format ddmonyyyy, such as 11NOV1992.

o Create a new variable num1 that converts the Charnum variable to a numeric variable.

What is the value ofChdatefor observation 52?

11. SIMULATION

Scenario:

This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in certprograms.

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