The TABULATE Procedure

Example 5: Customizing Row and Column Headings

Procedure features:

TABLE statement

labels

Data set:

ENERGY

Formats:

REGFMT., DIVFMT., and USETYPE.

This example shows how to customize row and column headings. A label specifies text for a heading. A blank label creates a blank heading. PROC TABULATE removes the space for blank column headings from the table.

Program

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

proc tabulate data=energy format=dollar12.;

   class region division type;

   var expenditures;

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

         / rts=25;

   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  |
              |-----------------------+------------+------------|
              |Region     |Division   |            |            |
              |-----------+-----------|            |            |
              |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