B.
Mv is clothes
C.
Mv is shoes
D.
Mv is tents
Item 40 of 63 Mark item for review
Which of the following SAS System options can aid in benchmarking?
A.
BUFSIZE= and BUFNO=
B.
FULLSTIMER
C.
IOBLOCKSIZE=
D. SYSTIMER
Item 41 of 63 Mark item for review
Given the following macro program:
%macro MAKEPGM(NEWNAME, SETNAME, PRINT); data &NEWNAME; set &SETNAME; run;
%if &PRINT=YES %then %do;
proc print data=&NEWNAME.(obs=10); run ; %end; %mend;
Which option would provide feedback in the log about the parameter values passed into this macro when invoked?
A. MPRINT
B. MDEBUG
C. MLOGIC
D. MPARAM
Item 42 of 63 Mark item for review
The NOTSORTED option on the BY statement cannot be used with which other statement or option?
A. SET
B. MERGE
C.
IF FIRST.by-variable
D.
BY GROUPFORMAT by-variable
Item 43 of 63 Mark item for review
Given the SAS data set WORK.ONE:
Rep Cost ----- ---- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100
The following SAS program is submitted:
proc sql; select Rep,
avg(Cost) as Average from WORK.ONE
[either__insert_SQL_where_clause_] group by Rep
[_or_ _insert_SQL_having_clause_] ; quit;
The following output is desired:
Rep Average ----- ------- SMITH 400
Which SQL clause completes the program and generates the desired output?
A.
where calculated Average > (select avg(Cost) from WORK.ONE)
B.
having Average > (select avg(Cost) from WORK.ONE)
C.
having avg(Cost) < (select avg(Cost) from WORK.ONE)
D.
where avg(Cost) > (select avg(Cost) from WORK.ONE)
Item 44 of 63 Mark item for review
Which dictionary table provides
information on each occurrence of the variable named LastName?
A.
DICTIONARY.TABLES
B.
DICTIONARY.COLUMNS
C.
DICTIONARY.MEMBERS
D.
DICTIONARY.VARIABLES
Item 45 of 63 Mark item for review
To create a list of unique Customer_Id
values from the customer data set, which of the following techniques can be used?
technique 1: proc SORT with NODUPKEY and OUT=
technique 2: data step with IF FIRST.Customer_Id=1 technique 3: proc SQL with the SELECT DISTINCT statement
A.
only technique 1
B.
techniques 1 and 2
C.
techniques 1 and 3
D.
techniques 1, 2, or 3
Item 46 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 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
