A00-231 Dumps Updated: Boost Your SAS 9.4 Base Programming — Performance-based Exam Preparation with DumpsBase’s A00-231 Dumps (V9.02)

1. SIMULATION

Scenario:

This project will use data setcert.input04. At any time, you may save your program asprogram04incertprograms. 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:

2. SIMULATION

Scenario:

This project will use data setcert.input04. At any time, you may save your program asprogram04incertprograms. 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.sasincertprograms before continuing with the next project

3. SIMULATION

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 observations (rows) are inresults.match08?

Enter your numeric answer in the space below:

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

5. 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 observations (rows) are inresults.nomatch08?

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

7. SIMULATION

Scenario:

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

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)

8. SIMULATION

Scenario:

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

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.

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

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