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

NOSEPS removes the separator lines from the row titles and the body of the table. INDENT= eliminates the row headings for Region and Division, and indents values for Division underneath values for Region.

Chapter Contents
Previous
Next
Top of Page

NOSEPS removes the separator lines from the row titles and the body of the table. INDENT= eliminates the row headings for Region and Division, and indents values for Division underneath values for Region.