SAS Certified Specialist Base Programming Certification (A00-231) - SASI Exam Questions

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:

The following SAS program is submitted:



Which output is correct?

SIMULATION

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:

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

Enter your numeric answer in the space below:

SIMULATION

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