Previous Page | Next Page

The TABULATE Procedure

Example 7: Eliminating Row Headings


Procedure features:

TABLE statement:

labels

ROW=FLOAT

Data set: ENERGY
Formats: REGFMT., DIVFMT., and USETYPE.

This example shows how to eliminate blank row headings from a table. To do so, you must both provide blank labels for the row headings and specify ROW=FLOAT in the TABLE statement.


Program

 Note about code
options nodate pageno=1 linesize=80 pagesize=60;
 Note about code
proc tabulate data=energy format=dollar12.;
 Note about code
   class region division type;
 Note about code
   var expenditures;
 Note about code
   table region*division*expenditures=' '*sum=' ',
 Note about code
         type='Customer Base'
 Note about code
         / rts=25 row=float;
 Note about code
   format region regfmt. division divfmt. type usetype.;
 Note about code
   title 'Energy Expenditures for Each Region';
   title2 '(millions of dollars)';
run;

Output

 Note about figure
                      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|
              ---------------------------------------------------

Previous Page | Next Page | Top of Page