ProdId    Price    ProductType    Sales    Returns

  ------    -----    -----------    -----    -------

  K12S      95.50    OUTDOOR           15          2

  B132S      2.99    CLOTHING         300         10

  R18KY2    51.99    EQUIPMENT         25          5

  3KL8BY     6.39    OUTDOOR          125         15

  DY65DW     5.60    OUTDOOR           45          5

  DGTY23    34.55    EQUIPMENT         67          2

The following SAS program is submitted:

data WORK.OUTDOOR WORK.CLOTH WORK.EQUIP;

     set WORK.PRODUCTS;

     if Sales GT 30;

     if  ProductType EQ 'OUTDOOR'  then output WORK.OUTDOOR;

     else if ProductType EQ 'CLOTHING' then output WORK.CLOTH;

     else if ProductType EQ 'EQUIPMENT' then output WORK.EQUIP;

run;

How many observations does the WORK.OUTDOOR data set contain?

A. proc contents lib=WORK run;

B. proc contents lib=WORK.all;run;

C. proc contents data=WORK._all_; run;

D. proc contents data=WORK _ALL_; run;

A. libname "_SAS_data_library_location_";

B. sasdata libname "_SAS_data_library_location_";

C. libname sasdata "_SAS_data_library_location_";

D. libname sasdata sas "_SAS_data_library_location_";

  ----|----10---|----20---|----30

  Susan*12/29/1970*10

  Michael**6

The following output is desired:

  Obs  employee   bdate  years

   1   Susan       4015    10

   2   Michael        .     6

Which SAS program correctly reads in the raw data?

 proc print data=SASHELP.CLASS(firstobs=5 obs=15);

    where Sex='M';

 run;

How many observations will be displayed?

A. proc sort out=EMPLOYEES data=EMPSORT;

             by Lname and Fname;

     run;

B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT;

            by Lname Fname;

    run;

C. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;

            by Lname Fname;

     run;

D. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;

            by Lname and Fname;

     run;

  Day  Month  Temp

  ---  -----  ----

    1  May     75

   15  May     70

   15  June    80

    3  June    76

    2  July    85

   14  July    89

The following program is submitted:

  proc sort data=WORK.TEMPS;

          by descending Month Day;

  run;

  proc print data=WORK.TEMPS;

  run;

Which output is correct?