SAS Chapter 8: Creating Enhanced Reports

10 Questions | Total Attempts: 176

SettingsSettingsSettings
SAS Chapter 8: Creating Enhanced Reports

Practice for the SAS basic certification exam.


Questions and Answers
  • 1. 
    If Style has four unique values and you submit the following program, which output do you get?  (Assume that all other variables are numeric.) proc report data=sasuser.houses nowd;    column style sqfeet bedrooms price;    define style / group; run;
    • A. 

       

    • B. 
    • C. 
    • D. 
  • 2. 
    When you define an order variable,
    • A. 

      The detail rows are ordered according to their formatted values.

    • B. 

      You can't create summary reports.

    • C. 

      PROC REPORT displays only the first occurrence of each order variable value in a set of rows that have the same value for all order variables,

    • D. 

      All of the above

  • 3. 
    Which attributes or options are reflected in this PROC REPORT output?
    • A. 

      SKIPLINE and FORMAT=

    • B. 

      CENTER, HEADLINE, HEADSKIP, and either WIDTH=, SPACING=,or FORMAT=

    • C. 

      SPACING= only

    • D. 

      CENTER, FORMAT=, and HEADLINE

  • 4. 
    To create a summary report that shows the average number of bedrooms and the maximum number of baths for each style of house, which DEFINE statements do you use in your PROC REPORT step?
    • A. 

      Define style / center 'Style of/House'; define bedrooms / mean 'Average/Bedrooms'; define baths / max 'Maximum/Baths';

    • B. 

      Define style / group; define bedrooms / mean 'Average/Bedrooms'; define baths / max 'Maximum/Baths';

    • C. 

      Define style / order; define bedrooms / mean 'Average/Bedrooms'; define baths / max 'Maximum/Baths';

    • D. 

      Define style / group; define bedrooms / 'Average/Bedrooms'; define baths /'Maximum/Baths';

  • 5. 
    Which program does not contain an error?
    • A. 

      Proc report data=sasuser.houses nowd;    column style bedrooms baths;    define style / order;    define bedbathratio / computed format=4.2;    compute bedbathratio;       bedbathratio=baths.sum/bedrooms.sum; endcomp; run;

    • B. 

      Proc report data=sasuser.houses nowd;    column style bedrooms baths BedBathRatio;    define style / order;    define bedbathratio / order format=4.2;    compute bedbathratio;       bedbathratio=baths.sum/bedrooms.sum; endcomp; run;

    • C. 

      Proc report data=sasuser.houses nowd;    column style bedrooms baths BedBathRatio;    define style / order;    define bedbathratio / computed format=4.2;    compute bedbathratio;       bedbathratio=baths.sum/bedrooms.sum; endcomp; run;

    • D. 

      Proc report data=sasuser.houses nowd;    column style bedrooms baths BedBathRatio;    define style / order;    define bedbathratio / computed format=4.2;    compute bedbathratio;       bedbathratio=baths/bedrooms;    endcomp; run;

  • 6. 
    What output does this PROC REPORT step produce? proc report data=sasuser.houses nowd;    column style sqfeet bedrooms price; run;
    • A. 

      A list report ordered by values of the first variable in the column statement

    • B. 

      A summary report ordered by values of the first variable in the COLUMN statement

    • C. 

      A list report that displays a row for each observation in the input data set and which calculates the SUM statistic for numeric variables

    • D. 

      A list report that calculates the N (frequency) statistic for character variables

  • 7. 
    Which of the following programs produces this output?
    • A. 

      Proc report data=sasuser.houses nowd;    column style condo range split           twostory price;    define price / mean 'Average Price'; run;

    • B. 

      Proc report data=sasuser.houses nowd;    column style price;    define style / group;    define price / mean 'Average Price'; run;

    • C. 

      Proc report data=sasuser.houses nowd;    column style price;    define style / across;    define price / mean 'Average Price'; run;

    • D. 

      Proc report data=sasuser.houses nowd;    column style price;    define style / across 'CONDO'  'RANCH'           'SPLIT' 'TWOSTORY';    define price / mean 'Average Price'; run;

  • 8. 
    If you submit this program, where does your PROC REPORT output appear? proc report data=sasuser.houses nowd;    column style sqfeet bedrooms price;    define style / group; run;
    • A. 

      In the PROC REPORT window

    • B. 

      As HTML and/or SAS listing output

    • C. 

      Both of the above

    • D. 

      Neither of the above

  • 9. 
    How can you create output with headings that break as shown below?
    • A. 

      You must specify the SPLIT= option in the PROC REPORT statement and use the split character in the column headings in DEFINE statements.

    • B. 

      You must use the default split character in column headings in DEFINE statements.

    • C. 

      You must specify either the width= or the SPACING= attribute in DEFINE statements.

    • D. 

      These headings split this way by default.

  • 10. 
    Suppose you want to create a report using both character and numeric variables.  If you don't use any DEFINE statements in your PROC step,
    • A. 

      Your PROC REPORT step will not execute successfully.

    • B. 

      You can produce only list reports.

    • C. 

      You can order rows by specifying options in the PROC REPORT statement.

    • D. 

      You can produce only summary reports.

Related Topics
Back to Top Back to top