SAS Chapter 8: Creating Enhanced Reports

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Moxleyv
M
Moxleyv
Community Contributor
Quizzes Created: 38 | Total Attempts: 21,964
| Attempts: 484
SettingsSettings
Please wait...
  • 1/10 Questions
    Which attributes or options are reflected in this PROC REPORT output? - ProProfs

    Which attributes or options are reflected in this PROC REPORT output?

    • SKIPLINE and FORMAT=
    • CENTER, HEADLINE, HEADSKIP, and either WIDTH=, SPACING=,or FORMAT=
    • SPACING= only
    • CENTER, FORMAT=, and HEADLINE
Please wait...
SAS Chapter 8: Creating Enhanced Reports - Quiz
About This Quiz

This quiz assesses skills in creating enhanced reports using SAS, focusing on PROC REPORT functionalities. It evaluates understanding of group and order variables, computed fields, and summarizing data, essential for effective data presentation and analysis in SAS.

Quiz Preview

  • 2. 

    When you define an order variable,

    • The detail rows are ordered according to their formatted values.

    • You can't create summary reports.

    • 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,

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    Order variables do order rows according to the formatted values of the order variable, and PROC REPORT suppresses repetitious printing of order values. However, you can't use order variables in a summary report.

    Rate this question:

  • 3. 

    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;

    • In the PROC REPORT window

    • As HTML and/or SAS listing output

    • Both of the above

    • Neither of the above

    Correct Answer
    A. As HTML and/or SAS listing output
    Explanation
    In nonwindowing mode, your PROC REPORT output appears as HTML and/or as SAS listing output, depending on your option settings.

    Rate this question:

  • 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?

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

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

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

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

    Correct Answer
    A. Define style / group; define bedrooms / mean 'Average/Bedrooms'; define baths / max 'Maximum/Baths';
    Explanation
    To create a summary report, you must define a group variable. To produce the statistics that you want, you must specify the MEAN and MAX statistics for Bedrooms and Baths.

    Rate this question:

  • 5. 

    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,

    • Your PROC REPORT step will not execute successfully.

    • You can produce only list reports.

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

    • You can produce only summary reports.

    Correct Answer
    A. You can produce only list reports.
    Explanation
    Unless you use DEFINE statements to define order variables or group variables, you can't order rows or produce summary reports. However, DEFINE statements are not required in PROC REPORT steps.

    Rate this question:

  • 6. 

    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;

    Correct Answer
    A.  
    Explanation
    This program creates a summary report, which consolidates into one row all observations from the data set that have a unique combination of values for the variable Style.

    Rate this question:

  • 7. 

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

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

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

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

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

    Correct Answer
    A. A list report that displays a row for each observation in the input data set and which calculates the SUM statistic for numeric variables
    Explanation
    By default, PROC REPORT displays character variables as display variables. A report that contains one or more display variables has a detail row for each observation in the data set.

    Rate this question:

  • 8. 
    Which of the following programs produces this output? - ProProfs

    Which of the following programs produces this output?

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

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

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

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

    Correct Answer
    A. Proc report data=sasuser.houses nowd;    column style price;    define style / across;    define price / mean 'Average Price'; run;
    Explanation
    In this output, the table cells contain a frequency count for each unique value of an across variable, Style. You don't have to specify across variable values in your PROC REPORT step.

    Rate this question:

  • 9. 

    Which program does not contain an error?

    • 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;

    • 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;

    • 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;

    • 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;

    Correct Answer
    A. 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;
    Explanation
    Program c correctly specifies a computed variable in the COLUMN statement, defines the variable in a DEFINE statement, and computes values using the form variable-name.statistic in a compute block.

    Rate this question:

  • 10. 
    How can you create output with headings that break as shown below? - ProProfs

    How can you create output with headings that break as shown below?

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

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

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

    • These headings split this way by default.

    Correct Answer
    A. These headings split this way by default.
    Explanation
    By default, columns for character variables are the same as the variable's length, and columns for numeric variables have a width of 9. So these headings split this way by default.

    Rate this question:

Quiz Review Timeline (Updated): Mar 18, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 23, 2013
    Quiz Created by
    Moxleyv
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.