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  ;