发帖
雷达卡
Item 1 of 63 Mark item forreview A or C ？
When attempting to minimize memoryusage, the
most efficient way to do groupprocessing when
using the MEANS procedure is touse:
A.
the BY statement.
B.
GROUPBY with the NOTSORTEDspecification.
C.
the CLASS statement.
D.
multiple WHERE statements.
Item 7 of 63 Mark item forreview A or C ？
A quick rule of thumb for thespace
required to run PROC SORT is:
A. two times the size of the SAS dataset being sorted.
B. three times the size of the SAS dataset being sorted.
C. four times the size of the SAS dataset being sorted.
D. five times the size of the SAS dataset being sorted.
Item 26 of 63 Mark item forreview A or D ？
Given the following SAS datasets:
WORK.VISIT1 WORK.VISIT2
Id Expense Id Cost
--- ------- --- ----
001 500 001 300
001 400 002 600
003 350
The following result set wassummarized and
consolidated using the SQLprocedure:
Id Cost
--- ----
001 300
001 900
002 600
003 350
Which of the following SQLstatements was
most likely used to generate thisresult?
A. select Id,
sum(Expense) label='COST'
from WORK.VISIT1
group by 1
union all
select Id,
sum(Cost) from WORK.VISIT2
group by 1 order by 1,2 ;
B. select id, sum(expense) as COST from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2where VISIT1.Id=VISIT2.Id
group by Id order by Id, Cost;
C. select VISIT1.Id, sum(Cost) as Cost
from WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2where VISIT1.Id=VISIT2.Id
group by Id order by Id, Cost;
D. select Id,
sum(Expense) as Cost from WORK.VISIT1group by Id
outer union corrselect Id,
sum(Cost) from WORK.VISIT2
group by Id order by 1,2 ;
京公网安备 11010802022788号
