A00-202 Online Practice Questions and Answers
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 bytes; BUFNO= specifies the number of output buffers.
C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
Given the following SAS data sets ONE and TWO:
ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
------------------------------ ---------------------------- 2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one, two;
quit;
Which one of the following reports is generated?
A. YEAR QTR BUDGET SALES
2001 4 400 300
2002 1 700 600
B. YEAR QTR BUDGET SALES
2001 3 500 .
2001 4 400 300
2002 1 700 600
C. YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 600
D. YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 300
2001 3 500 600
2001 4 400 600
2002 1 700 600
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 COUNT
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
B. REP AREA TOTAL
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
C. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
D. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1
Which one of the following SAS programs uses the most amount of memory resources for output buffers?
A. data new(bufsize = 1000 bufno = 5); set temp; run;
B. data new(bufsize = 1000 bufno = 2); set temp; run;
C. data new(bufsize = 2000 bufno = 3); set temp; run;
D. data new(bufsize = 4000 bufno = 1); set temp; run;
Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
--------------------------- ----------------------------- 1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted:
data combine;
merge one two;
by common;
run;
Which one of the following represents the data values stored in data set COMBINE?
A. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 A 14 3
4 B 9 4
5 B 9 2
6 C 8 5
7 C 14 5
B. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 9 4
4 C 8 5
C. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 14 4
4 B 9 2
5 C 8 5
D. OBS COMMON X Y
1 A 10 1
2 A 13 1
3 A 14 1
4 A 10 3
5 A 13 3
6 A 14 3
7 B 9 4
8 B 9 2
9 C 8 5
10 C 14 5
The following SAS program is submitted:
%macro test(var);
%let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
%let type = %index(andjobs,andvar);
%mend;
%test(SMITH)
Which one of the following is the resulting value of the macro variable TYPE?
A. 0
B. 3
C. 6
D. null
Given the following SAS data sets ONE and TWO:
ONE TWO NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country from one where not exists
(select * from two where one.num = two.num);
quit;
Which one of the following reports is generated?
A. COUNTRY
GERMANY
JAPAN
B. COUNTRY
FRANCE
BELGIUM
C. COUNTRY
CANADA
FRANCE
BELGIUM
D. COUNTRY
CANADA
FRANCE
GERMANY
Which one of the following options is available for SAS macro debugging?
A. MLOGIC
B. MDEBUG
C. MSGLEVEL
D. MAUTOSOURCE
The following SAS program is submitted: %let name = Patel's Restaurant;
Which one of the following statements avoids problems associated with the unbalanced quotation mark?
A. %let name = Patel%'s Restaurant;
B. %let name = %str(Patel's Restaurant);
C. %let name = Patel%str(')s Restaurant;
D. %let name = %str(Patel%'s Restaurant);
Given the following SAS data sets ONE and TWO:
ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
------------------------------- ----------------------------- 2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one left join two
on one.year = two.year;
quit;
Which one of the following reports is generated?
A. YEAR QTR BUDGET SALES 2001 3 500 .
B. YEAR QTR BUDGET SALES
2001 4 400 300
2002 1 700 600
C. YEAR QTR BUDGET SALES
2001 3 500 .
2001 4 400 300
2002 1 700 600
D. YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 600