SAS A00-231 Exam Questions Instant Access

Question 1

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

A117

Answer : A

proc sort data=cert.input08b out=work.input08b;

by ID;

run:

data results.match08 results.nomatch08 (drop=ex: );

merge work.input08a (in=a) work.input08b (in=b);

by ID;

if a and b then output results.match08;

else output results.nomatch08;

run;

proc contents data=results.match08;

SAS code that could be used to solve this project:

proc

sort data=cert.input08a out=work.input08a;

by ID;

run:

run;

proc contents data=results.nomatch08;

run;

The correct answer is: 117

Question 2

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:

Aby location;

Bclass location;

Cgroup by location;

Dby location; id location;

Answer : B

Question 3

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:

AX Y Z
-- -- --
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91

BX Y Z
-- -- --
1 A 27
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91

CX Y Z
-- -- --
1 A 33
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91

DX Y Z
-- -- --
1 A 27
1 B 45
2 A 52
2 B 69
4 A 82
4 C 91

Answer : B

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

Answer : A

SAS code that could be used to solve this project:

Proc

sort data=cert.input08a out=work.input08a;

by ID;

run;

proc sort data=cert.input08b out=work.input08b;

by ID;

run;

data results.match08 results.nomatch08 (drop=ex: );

merge work.input08a (in=a) work.input08b (in=b);

by ID;

if a and b then output results.match08;

else output results.nomatch08;

run;

proc contents data=results.match08;

run;

proc contents data=results.nomatch08;

run;

The correct answer is: 5

Question 5

SIMULATION

Scenario:

Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram48incert\programs. 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:

A47

Answer : A

Question 6

Given the following SAS data set WORK.TOYS:

Product Group Price

--------- ----------- -----

Cards Indoors 9.99

Marbles Indoors 8.99

Drum Instruments 12.99

Hula-Hoop Outdoors 12.99

Ball Outdoors 8.49

The following SAS program is submitted:

data WORK.GROUPS;

set WORK.TOYS;

if Group="Outdoors" then Price_Gp="C";

if Price ge 12.99 then Price_Gp="A";

else if Price ge 8.99 then Price_Gp="B";

run;

What will be the value of Price_Gp for Hula-Hoop and Ball? Select one:

AHula-Hoop: 'A', Ball: ' ' (missing value)

BHula-Hoop: 'A', Ball: 'C'

CHula-Hoop: 'C', Ball: ' ' (missing value)

DHula-Hoop: 'C', Ball: 'C'

Answer : B

Question 7

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

Select one:

Adata work.airport;
AirportCode='ord';
if (AirportCode='ord') City='Chicago';
run;

Bdata work.airport;
AirportCode='ORD';
if AirportCode='ORD' then City=Chicago;
run;

Cdata work.airport;
AirportCode='ORD';
if AirportCode='ORD';
then City='Chicago';
run;

Ddata work.airport;
AirportCode='ORD';
if AirportCode='ORD' then City='Chicago';
run;

Answer : B

SAS 9.4 Base Programming - Performance-Based A00-231 Exam Questions