Desired %PUT Results in LOG: My favorite surprise is a movie
What is the correct %PUT statement that generates the desired results?
A.
%put My favorite &Thing&Pick is a &&Choice&Pick;
B.
%put My favorite &&Thing&pick is a &&&Choice&Pick;
C.
%put My favorite &Choice&pick is a &&Thing&Pick;
D.
%put My favorite &&Choice&pick is a &&&Thing&Pick;
Item 34 of 63 Mark item for review
Given the SAS dataset WORK.ONE
Name Salary ----- ------ Hans 200 Maria 205 Jose 310 Ariel 523
The following SAS program is submitted:
proc sql;
[_insert_select_clause_] from WORK.ONE ; quit;
The following output is desired:
Salary Bonus ------ ----- 200 20 205 20.5 310 31 523 52.3
Which SQL procedure clause completes
the program and generates the desired output?
A.
select Salary Bonus as Salary*.10 as Bonus
B.
select Salary Bonus=Salary*.10 'Bonus'
C.
select Salary, Salary*.10 label='Bonus'
D.
select Salary, Salary*.10 column=\Item 35 of 63 Mark item for review
The following SAS program is submitted:
options reuse=YES;
data SASUSER.REALESTATE(compress=CHAR); set SASUSER.HOUSES; run;
What is the effect of
the reuse=YES SAS system option?
A.
It allows updates in place.
B.
It tracks and recycles free space.
C.
It allows a permanently stored SAS data set to be replaced.
D.
It allows users to access the same SAS data set concurrently.
Item 36 of 63 Mark item for review
Which statement is true for Data step HASH objects?
A.
The key component must be numeric.
B.
The data component may consist of numeric and character values.
C.
The HASH object is created in one step and referenced in another.
D.
The HASH object must be smaller than 2 to the 8th power bytes.
Item 37 of 63 Mark item for review
Given the SAS data sets:
WORK.CLASS1 WORK.CLASS2
Name Course Name Class ------ ------ ------- ----- Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2
Chang MATH3 Hillier MATH2
The following SAS program is submitted:
proc sql; select Name
from WORK.CLASS1
[_insert_set_operator_] select Name
from WORK.CLASS2 ; quit;
The following output is desired:
Name ------ Chang Chang Lauren
Which SQL set operator completes the program and generates the desired output?
A.
intersect corr
B. except all
C.
intersect all
D.
left except
Item 38 of 63 Mark item for review
The following SAS program is submitted:
%macro CHECK(Num=4);
%let Result=%eval(&Num gt 5); %put Result is &result; %mend;
%check(Num=10)
What is written to the SAS log?
A.
Result is 0
B.
Result is 1
C.
Result is 10 gt 5
D.
Result is true
Item 39 of 63 Mark item for review
The following SAS program is submitted:
%let Mv=shoes;
%macro PRODUCT(Mv=bicycles); %let Mv=clothes; %mend;
%PRODUCT(Mv=tents) %put Mv is &Mv;
What is written to the SAS log?
A.
Mv is bicycles
