A 13 3 B 14 4 B 9 2
B.
Common X Y ------ -- -- A 10 1 A 13 3 A 14 3 B 9 4 B 9 2
C.
Common X Y ------ -- -- A 10 1 A 13 3 A 14 . B 9 4 B . 2
D.
Common X Y ------ -- -- A 10 1 A 13 1 A 14 1 A 10 3 A 13 3 A 14 3 B 9 4 B 9 2
Item 28 of 63 Mark item for review
Which of the following ARRAY statements is similar to the statement array Yr{1974:2007} Yr1974-Yr2007; and will compile without errors?
A.
array Yr{34} Yr1974-Yr2007;
B.
array Yr{74:07} Yr1974-Yr2007;
C.
array Yr{74-07} Yr1974-Yr2007;
D.
array Yr{1974-2007} Yr1974-Yr2007;
Item 29 of 63 Mark item for review
The following program is submitted to check
the variables Xa, Xb, and Xc in the SASUSER.LOOK data set:
data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ; set SASUSER.LOOK(keep=Xa Xb Xc); length _Check_ $ 10 ;
if Xa=. then _check_=trim(_Check_)!!\ if Xb=. then _check_=trim(_Check_)!!\ if Xc=. then _check_=trim(_Check_)!!\ put Xa= Xb= Xc= _check_= ; run ;
When is the PUT statement executed?
A.
when the code is submitted
B.
only when the WORK.BAD_DATA view is used
C.
both when the code is submitted and the view is used
D.
never, the use of _null_ in a view is a syntax error
Item 30 of 63 Mark item for review
The following SAS program is submitted:
%let product=merchandise;
[_insert_%put_statement_]
and the following message is written to the SAS log:
the value is \
Which macro statement wrote this message?
A.
%put the value is '\
B.
%put the value is %quote(&product.);
C.
%put the value is \
D.
%put the value is \
Item 31 of 63 Mark item for review
Given the SAS data sets:
WORK.ONE WORK.TWO
X Y SumY -- -- ----
A 10 36 A 3 A 14 B 9
The following SAS DATA step is submitted:
data WORK.COMBINE;
if _n_=1 then set WORK.TWO; set WORK.ONE; run;
What data values are stored in data set WORK.COMBINE?
A.
An ERROR message is written to the SAS log and the data set WORK.COMBINE is not created.
B.
SumY X Y ---- -- -- 36 A 10
C.
SumY X Y ---- -- -- 36 A 10 . A 3 . A 14 . B 9
D.
SumY X Y ---- -- -- 36 A 10 36 A 3 36 A 14 36 B 9
Item 32 of 63 Mark item for review
The following SAS program is submitted:
data WORK.NEW(bufno=4); set WORK.OLD(bufno=3); run;
Why are the BUFNO options used?
A.
to reduce memory usage
B.
to reduce CPU time usage
C.
to reduce the amount of data read
D.
to reduce the number of I/O operations
Item 33 of 63 Mark item for review
Given the following program and desired results:
%let Thing1=gift; %let Thing2=surprise; %let Gift1=book; %let Gift2=jewelry; %let Surprise1=dinner; %let Surprise2=movie;
%let Pick=2;
%let Choice=surprise;