SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Quiz: Creating Tabular Reports

Select the best answer for each question and click Score My Quiz.

  1. Which program creates the following table?

      ActLevel All Levels
    HIGH LOW MOD
    Fee Sum 844.30 844.30 998.35 2686.95

     a.   
    proc tabulate data=clinic.admit;
   class actlevel;
   var fee;
   table fee sum,actlevel all;
   label all='All Levels';
run;
 
     b.   
    proc tabulate data=clinic.admit;
   var actlevel;
   class fee;
   table actlevel all fee;
   keylabel all='All Levels';           
run;
 
     c.   
    proc tabulate data=clinic.admit;
   class actlevel;
   var fee;
   table fee,actlevel all;
   keylabel all='All Levels';           
run;
 
     d.   
    proc tabulate data=clinic.admit;
   class actlevel;
   var fee;
   table actlevel all,fee;
   keylabel all='All Levels';           
run;

  2. Which TABLE statement correctly requests statistics to show average sales?

     a.   
    table region,sales(mean),year;
     b.   
    table year salesrep*sales*average;
     c.   
    table salesrep*year,sales mean;
     d.   
    table region,year,sales*mean;

  3. Which table does the following program create? 
      proc tabulate data=clinic.heart format=6.;
     class sex survive;
     var arterial cardiac;
     table sex survive all,arterial*max cardiac*min;
  run;

     a.  
      Arterial Cardiac
    Max Min
    Sex 103 66
    1
    2 145 156
    Survive 145 95
    DIED
    SURV 88 66
    All 145 66
     
     b.  
      Arterial Cardiac
    Max Min
    Sex Survive 103.00 95.00
    1 DIED
    SURV 88.00 66.00
    2 DIED 145.00 156.00
    SURV 87.00 256.00
    All 145.00 66.00
     

     c.  
      Sex Survive All
    1 2 DIED SURV
    Arterial Max 103.00 145.00 145.00 88.00 145.00
    Cardiac Min 66.00 156.00 95.00 66.00 66.00
     
     d.  
      Sex Survive All
    1 2 DIED SURV
    Arterial Max 103 145 145 88 145
    Cardiac Min 66 156 95 66 66

  4. If the error message Variable VARIABLE in list does not match type prescribed for this list occurs, what has happened?

     a.   You specified a numeric variable as class.
     b.   You specified a character variable as analysis.
     c.   You forgot to specify a variable as either class or analysis.
     d.   You specified a variable as both class and analysis.

  5. What type of table does this TABLE statement create? 
         table dest*n orig*n boarded*pctsum 
               transferred*pctsum deplaned revenue;

     a.   a one-dimensional table
     b.   a two-dimensional table
     c.   a three-dimensional table
     d.   the TABLE statement is incorrectly specified

  6. How many dimensions does the table below contain?

    Year 2000
      AerClass WalkJogRun Swim
    Min 61.00 118.00 22.00
    Max 81.00 136.00 44.00
    Mean 71.00 127.00 33.00

     a.   one
     b.   two
     c.   three
     d.   can't tell from the output shown

  7. Which PROC TABULATE step below is correctly specified?

     a.   
    proc tabulate data=finance.loans;
   class customertype;
   table customertype n,pctn;          
run;
 
     b.   
    proc tabulate data=finance.loans;
   class customertype;
   var customertype;
   table customertype,n;          
run;
 
     c.   
    proc tabulate data=finance.loans;
   var customertype;
   table customertype amount,n;          
run;
 
     d.   
    proc tabulate data=finance.loans;
   class customertype;
   table customertype,n pctn;          
run;

  8. Why is the following PROC TABULATE step incorrect, given that Survive and Shock are character variables? 
    proc tabulate data=clinic.heart;
   var survive shock;
   table survive shock,sum pctsum;
run;

     a.   The wrong statistics are requested for the variables.
     b.   The variables are specified as analysis variables instead of class variables.
     c.   The variables and statistics are specified in different dimensions.
     d.   only a and b above

  9. What happens when you submit the program below? 
    proc tabulate data=clinic.admit;
   class actlevel sex;
   table actlevel,sex;
   where actlevel='HIGH';
run;

     a.   The table has only one column.
     b.   The table has only one row.
     c.   The table has two columns and two rows.
     d.   The program causes error messages and stops processing.

  10. What statistic is calculated in the PROC TABULATE step below? 
    proc tabulate data=clinic.heart;
   class survive;
   var cardiac urinary;
   table survive,cardiac urinary;
run;

     a.   N and PCTN for Survive and SUM and PCTSUM for Cardiac and Urinary
     b.   N for Survive and SUM for Cardiac and Urinary
     c.   SUM for Cardiac and Urinary within categories of Survive
     d.   none of the above


back||next

Terms of Use & Legal Information | Privacy Statement