The PRINT Procedure

Example 4: Summing Numeric Variables with One BY Group

Procedure features:

PROC PRINT statement options:

BY statement

SUM statement

Other features:

SORT procedure

TITLE statement

#BYVAL specification

SAS system options :

	BYLINE
	NOBYLINE

Data set:

EXPREV

This example

sums expenses and revenues for each region and for all regions
shows the number of observations in each BY group and in the whole report
creates a customized title, containing the name of the region. This title replaces the default BY line for each BY group.

Program

options nodate pageno=1 linesize=70 pagesize=60 nobyline;

proc sort data=exprev; by region; run;

proc print data=exprev noobs n='Number of observations for the state: ' 'Number of observations for the data set: ';

sum expenses revenues; by region;

format revenues expenses comma10.;

title 'Revenue and Expense Totals for the #byval(region) Region'; run;

options byline;

Output

Chapter Contents
Previous
Next
Top of Page