Chapter Contents

Previous

Next
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;
proc tabulate data=energy format=dollar12.;
 Note about code
   class region division type;
   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.;
   title 'Energy Expenditures for Each Region';
   title2 '(millions of dollars)';
run;


Output
Compare this table with the table in Customizing Row and Column Headings . The two tables are identical, but the program that creates the table uses Expenditures and Sum in the column dimension. PROC TABULATE automatically eliminates blank headings from the column dimension, whereas you must specify ROW=FLOAT to eliminate blank headings from the row dimension. [HTML Output]
 [Listing Output]


Chapter Contents

Previous

Next

Top of Page

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