The PRINT Procedure

Example 8: Creating a Customized Layout with BY Groups and ID Variables

Procedure features:

BY statement

ID statement

SUM statement

VAR statement

Other features:

SORT procedure

Data set:

EMPDATA

This customized report

selects variables to include in the report and controls their order
selects observations to include in the report
groups the selected observations by JobCode
sums the salaries for each job code and for all job codes
displays numeric data with commas and dollar signs.

Program

options nodate pageno=1 linesize=64 pagesize=60; proc sort data=empdata out=tempemp; by jobcode gender; run;

proc print data=tempemp split='*';

id jobcode; by jobcode; var gender salary;

sum salary;

label jobcode='Job Code*========' gender='Gender*======' salary='Annual Salary*=============';

format salary dollar11.2; where jobcode contains 'FA' or jobcode contains 'ME'; title 'Expenses Incurred for'; title2 'Salaries for Flight Attendants and Mechanics'; run;

Output

The ID and BY statements work together to produce this layout. The ID variable is listed only once for each BY group. The BY lines are suppressed. Instead, the value of the ID variable, JobCode, identifies each BY group.

Chapter Contents
Previous
Next
Top of Page

The ID and BY statements work together to produce this layout. The ID variable is listed only once for each BY group. The BY lines are suppressed. Instead, the value of the ID variable, JobCode, identifies each BY group.