Example 6.5. Adding “Traffic Lighting” to a Report Created by PROC TABULATE

Goal

Customize the appearance of the report produced in the related technique of Example 3.2 by modifying style attributes with ODS. Use “traffic lighting” to draw attention to specific results in the report by setting style elements to specific colors. Send the output to a nonlisting destination.

Report

Example Features

Example Overview

The report in the Related Technique section of Example 3.2 shows descriptive statistics for several combinations of classifications in the BREAD data set. This example presents only the table produced by the last request in the TABLE statement. The last table request computes descriptive statistics on calories and dietary fiber for the categories defined by the combination of the values of SOURCE and BRAND.

The report in this example visually identifies the means above and below specific values by setting the background color of the cell. Formats created by PROC FORMAT associate ranges of values to colors. A format is defined for ranges of calorie values, and a format is defined for ranges of dietary fiber values. The program applies each format to the mean statistic of the specific analysis variable by setting the background style element attribute to the format name.

Program

proc format;

  value colorcal low-85='graycc'
                 95-high='grayee';

  value colorfib low-1.8='grayee'
                 2-high='graycc';

run;

ods listing close;

ods rtf file='c:
eportsexample32.rtf';




proc tabulate data=bread;
  title 'Nutritional Information about Breads
 Available
         in the Region';
  title2 'Values Per Bread Slice, Calories in kcal,
          Fiber in Grams';

  class source brand / style={background=grayee};

  classlev source brand / style={background=white};

  var calories dietary_fiber /
               style={background=grayee};

  table source*brand,
        calories*(n*f=3.

        (mean*{style={background=colorcal.}}
         min max)*f=7.1)
         dietary_fiber*(n*f=3.

        (mean*{style={background=colorfib.}}
         min max)*f=7.1) /

        / box={style={background=white}}
        rts=30;

  keyword n mean min max / style={background=white};
run;

ods rtf close;

ods listing;