The TABULATE Procedure

Example 8: Indenting Row Headings and Eliminating Horizontal Separators

Procedure features:

PROC TABULATE statement options:

NOSEPS

TABLE statement options:

INDENT=

Data set:

ENERGY

Formats:

REGFMT., DIVFMT., and USETYPE.

This example shows how to condense the structure of a table by

removing row headings for class variables
indenting nested rows underneath parent rows instead of placing them next to each other
eliminating horizontal separator lines from the row titles and the body of the table.

Program

options nodate pageno=1 linesize=80 pagesize=60;

proc tabulate data=energy format=dollar12. noseps;

   class region division type;

   var expenditures;

    table region*division,
          type='Customer Base'*expenditures=' '*sum=' '

         / rts=25 indent=4;

   format region regfmt. division divfmt. type usetype.;

   title 'Energy Expenditures for Each Region';
   title2 '(millions of dollars)';
run;

Output

                      Energy Expenditures for Each Region                      1
                             (millions of dollars)

              ---------------------------------------------------
              |                       |      Customer Base      |
              |                       |-------------------------|
              |                       |Residential |  Business  |
              |                       | Customers  | Customers  |
              |-----------------------+------------+------------|
              |Northeast              |            |            |
              |    New England        |      $7,477|      $5,129|
              |    Middle Atlantic    |     $19,379|     $15,078|
              |West                   |            |            |
              |    Mountain           |      $5,476|      $4,729|
              |    Pacific            |     $13,959|     $12,619|
              ---------------------------------------------------

Top of Page