(select avg(Salary) from WORK.PILOTS
group by Jobcode) as Avg from WORK.PILOTS order by Id ;
D. select
Jobcode, Salary, Avg from
WORK.PILOTS, (select
Jobcode as Jc, avg(Salary) as Avg from WORK.PILOTS group by 1) where Jobcode=Jc order by Id ;
Item 7 of 63 Mark item for review
A quick rule of thumb for the space required to run PROC SORT is:
A.
two times the size of the SAS data set being sorted.
B.
three times the size of the SAS data set being sorted.
C.
four times the size of the SAS data set being sorted.
D.
five times the size of the SAS data set being sorted.
Item 8 of 63 Mark item for review
Multi-threaded processing for PROC SORT will effect which of these system resources?
A.
CPU time will decrease,
wall clock time will decrease
B.
CPU time will increase,
wall clock time will decrease
C.
CPU time will decrease,
wall clock time will increase
D.
CPU time will increase, wall clock time will increase
Item 9 of 63 Mark item for review
Given the SAS data set WORK.TRANSACT:
Rep Cost Ship ----- ----- ----- SMITH 200 50 SMITH 400 20 JONES 100 10 SMITH 600 100 JONES 100 5
The following output is desired:
Rep
----- ---- JONES 105 SMITH 250
Which SQL statement was used?
A. select rep,
min(Cost+Ship)
from WORK.TRANSACT order by Rep ;
B. select Rep,
min(Cost,Ship) as Min from WORK.TRANSACT summary by Rep order by Rep ;
C. select Rep,
min(Cost,Ship)
from WORK.TRANSACT group by Rep order by Rep ;
D. select Rep,
min(Cost+Ship)
from WORK.TRANSACT group by Rep order by Rep ;
Item 10 of 63 Mark item for review
The following SAS program is submitted: %let Value=9; %let Add=5;
%let Newval=%eval(&Value/&Add); %put &Newval;
What is the value of the macro variable Newval when the %PUT statement executes?
A. 0.555
B. 2
C. 1.8
D. 1
Item 11 of 63 Mark item for review
The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP; infile RAWDATA; input Xa Xb Xc;
if Xa=. then output WORK.ERRORS; else output WORK.TEMP; run;
Which of the following is true of the WORK.ERRORS data set?
A.
The data set is created when the DATA step is submitted.
B.
The data set is created when the view TEMP is used in another SAS step.
C.
The data set is not created because the DATA statement contains a syntax error.
D.
The descriptor portion of WORK.ERRORS is created when the DATA step is submitted.
Item 12 of 63 Mark item for review
Which title statement would always display the current date?
A.
title \
B.
title \
C.
title \
D.
title \
Item 13 of 63 Mark item for review
Given the SAS data sets:
WORK.ONE WORK.TWO
