The TABULATE Procedure

Example 3: Using Preloaded Formats with Class Variables

Procedure features:

PROC TABULATE statement option:

OUT=

CLASS statement options:

	EXCLUSIVE
	PRELOADFMT

TABLE statement option:

PRINTMISS

Other features:

PRINT procedure

Data set:

ENERGY

Formats:

REGFMT., DIVFMT., and USETYPE.

This example

creates a table that includes all possible combinations of formatted class variable values (PRELOADFMT with PRINTMISS), even if those combinations have a zero frequency and even if they do not make sense
restricts the data in the table to combinations of formatted class variable values that appear in the input data set (PRELOADFMT with EXCLUSIVE).
writes the output to an output data set, and prints that data set.

Program

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

class region division type / preloadfmt; var expenditures;

table region*division, type*expenditures / rts=25 printmiss;

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

proc tabulate data=energy format=dollar12. out=tabdata;

class region division type / preloadfmt exclusive; 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;

proc print data=tabdata; run;

Output

Chapter Contents
Previous
Next
Top of Page