Chapter Contents
Previous
Next
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
 Note about code
options nodate pageno=1 linesize=80 pagesize=60;
proc tabulate data=energy format=dollar12.;
 Note about code
   class region division type;
   var expenditures;
 Note about code
    table region*division,
         type='Customer Base'*expenditures=' '*sum=' '










 Note about code
         / rts=25;


 Note about code
   format region regfmt. division divfmt. type usetype.;
   title 'Energy Expenditures for Each Region';
   title2 '(millions of dollars)';
run;

Output
The headings for Region, Division, and Type contain text specified in the TABLE statement. The TABLE statement eliminated the headings for Expenditures and Sum. [HTML Output]
 [Listing Output]


Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.