A00-212 Exam Training Practice Tests (SASInstitute SAS Advanced Programming Exam for SAS 9)]

Question 1

Which one of the following statements is true?

A. The WHERE statement selects observations before they are brought into the PDV. B. The WHERE statement can be executed conditionally as part of an IF statement. C. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs. D. The subsetting IF statement works on observations before they are read into the PDV.

Correct Answer: A

Question 2

Given the following SAS data set ONE:
ONE
REP AREA COST
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200
JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300
The following SAS program is submitted:
proc sql;
select rep, area, count(*) as TOTAL
from one
group by rep, area;
quit;
Which one of the following reports is generated?

A. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1 B. REP AREA TOTAL
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200 C. REP AREA COUNT
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200 D. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1

Correct Answer: A,D

Question 3

Given the following SAS data set ONE:
ONE
LEVEL AGE
1 10
2 20
3 20
2 10
1 10
2 30
3 10
2 20
3 30
1 10
The following SAS program is submitted:
proc sql;
select level, max(age) as MAX
from one
group by level
having max(age) > (select avg(age) from one);
quit;
Which one of the following reports is generated?

A. LEVEL MAX
2 30
3 30 B. LEVEL MAX
2 20
3 30 C. LEVEL AGE
2 20
3 20 D. LEVEL AGE
2 30
3 30

Correct Answer: A

Question 4

The following SAS program is submitted:
% macro check(num=4);
% let result=%eval(&nm gt 5);
% put result is &result;
% mend;
% check (num=10)
What is written to the SAS log?

A. result is 10 gt 5 B. result is 1 C. result is 0 D. result is true

Correct Answer: B

Question 5

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:
Proc sql;
Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year,
Quit;
The following output is desired:

Which JOIN operator completes the program and generates the desired output?

A. INNER JOIN B. FULL JOIN C. LEFT JOIN D. RIGHT JOIN

Correct Answer: B

Question 6

The following SAS program is submitted:
data temp;
array points{3,2}_temporary_ (10,20,30,40,50,60);
score = points{2,1}
run;
Which one of the following is the value of the variable SCORE in the data set TEMP?

A. 20 B. 30 C. 10 D. 40

Correct Answer: B

Question 7

The following SAS program is submitted:
data two;
y = '2';
run;
% let x = 10;
% let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;
Which one of the following is the value of the variable Z when the program finishes execution?

A. _ERROR_ B. 20 (as a character) C. . (missing numeric) D. 20 (as a numeric)

Correct Answer: D

Question 8

The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers. B. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers. C. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers. D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.

Correct Answer: C

Question 9

The following SAS program is submitted:
data temp;
array points{2,3} (10,15,20,25,30,35);
run;
What impact does the ARRAY statement have in the Program Data Vector(PDV)?

A. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5,
POINTS6 are created in the PDV B. No variable are created in the PDV C. The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV D. The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30,
POINTS35 are created in the PDV

Correct Answer: A

Question 10

Which one of the following options is available for SAS macro debugging?

A. MAUTOSOURCE B. MSGLEVEL C. MLOGIC D. MDEBUG

Correct Answer: C

Question 11

Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER
library?

A. proc datasets lib = sasuser._all_;
quit; B. proc datasets lib = sasuser;
contents data = _all_;
quit; C. proc datasets lib = sasuser;
contents data = all;
quit; D. proc datasets lib = sasuser.all;
quit;

Correct Answer: B

SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212 Exam Practice Test