B.
by Id grouped;
C.
by Id descending;
D.
by descending Id;
Item 52 of 63 Mark item for review
To create a dataset with unique values of a given varible using a data step and the FIRST. and LAST. varaibales, it is assumed that the input dataset is:
A.
sorted on that variable.
B.
indexed by that variable.
C.
naturally in order.
D.
any of the above A, B, or C
Item 53 of 63 Mark item for review
The SASFILE statement requests that a SAS data set be opened and loaded into memory:
A.
one page at a time.
B.
one variable at a time.
C.
one observation at a time.
D.
in its entirety, if possible.
Item 54 of 63 Mark item for review
The following SAS program is submitted:
%let Name1=Shoes; %let Name2=Clothes; %let Root=name; %let Suffix=2;
%put &&&Root&Suffix;
What is written to the SAS log?
A. &Name2
B. Clothes
C.
&&&Root&Suffix
D.
WARNING: Apparent symbolic reference ROOT2 not resolved.
Item 55 of 63 Mark item for review
Given the SAS data sets:
WORK.ONE WORK.TWO
Year Qtr Budget Year Qtr Sales ---- --- ------ ---- --- ----- 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2003 1 350
The following SAS program is submitted:
proc sql; select TWO.*, budget from WORK.ONE
[_insert_join_operator_] WORK.TWO
on ONE.Year=TWO.Year ; quit;
The following output is desired:
Year Qtr Sales Budget ---- --- ----- ------ 2001 4 300 500 2001 4 300 400 2002 1 600 . . . . 350
Which join operator completes the program and generates the desired output?
A. left join
B. right join
C. full join
D. outer join
Item 56 of 63 Mark item for review
The SAS data set WORK.ADDRESSES contains the email addresses of The XYZ Corporation's customers in a variable named Email_Address. The following DATA step is submitted:
data _null_;
set WORK.ADDRESSES; [_insert_statement_]
put \ put \ put \
put \ put \ put \ put \
put \ put \ run;
Which statement completes the program and creates a SAS program file?
A.
infile \
B.
output \
C.
file \
D.
None of the above.
Item 57 of 63 Mark item for review
Which of the following is true about the COMPRESS=YES data set option?
A.
It uses the Ross Data Compression method to compress numeric data.
B.
It is most effective with character data that contains repeated characters.
C.
It is most effective with numeric data that represents large numeric values.
D.
It is most effective with character data that
contains patterns, rather than simple repetitions.
Item 58 of 63 Mark item for review
Given the SAS dataset WORK.ONE:
Salary ------ 200 205 . 523
