The TABULATE Procedure

Example 1: Creating a Basic Two-Dimensional Table

Procedure features:

PROC TABULATE statement options:

FORMAT=

TABLE statement

crossing (* operator)

TABLE statement options:

RTS=

Other features:

FORMAT statement

This example

creates a category for each type of user (residential or business) in each division of each region
applies the same format to all cells in the table
applies a format to each class variable
extends the space for row headings.

Program

data energy; length State $2; input Region Division state $ Type Expenditures; datalines; 1 1 ME 1 708 1 1 ME 2 379 . . . more lines of data . . . 4 4 HI 1 273 4 4 HI 2 298 ;

proc format; value regfmt 1='Northeast' 2='South' 3='Midwest' 4='West'; value divfmt 1='New England' 2='Middle Atlantic' 3='Mountain' 4='Pacific'; value usetype 1='Residential Customers' 2='Business Customers'; run;

options nodate pageno=1 linesize=80 pagesize=60; proc tabulate data=energy format=dollar12.;

class region division type; var expenditures;

table region*division, type*expenditures

/ rts=25;

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

Output

Chapter Contents
Previous
Next
Top of Page