Doing More with SAS/ASSIST Software

Modifying a Report with Usages

The values of Usage define what a column represents and change the appearance of the report. The following table describes the different values of Usage. Note that SUM, MEAN, MIN, MAX, AVG, COUNT, N, and NMISS are aggregate (or summary) functions.

Usages
Usage Description

PAGE creates a new page at each new column value. PAGE is used with the ACROSS, GROUP, or BREAK usages. PAGE is valid only with a report of type TABLE. With other types of reports, PAGE is used like a GROUP usage. The corresponding SAS/GRAPH option for this usage is BY, which creates a new page for each BY value.

GROUP groups data by the values in the column. The corresponding SAS/GRAPH option for this usage is GROUP, which organizes bars and pies into groups by different values of the GROUP variable.

ACROSS groups the report into subgroups across the report. The corresponding SAS/GRAPH option for this usage is ACROSS, which is used to place multiple pies "across" on a page and also is used by the LEGEND statement.

BREAK computes one summary for each column in a LIST report. With other types of reports, BREAK is used like a GROUP usage.

SUM computes the sum of the values. The corresponding SAS/GRAPH option for this usage is SUM, which prints the value of the sum statistic above bars.

MEAN computes the mean of the values. The corresponding SAS/GRAPH option for this usage is MEAN, which is the value of the statistic for the variable being used for calculations.

MIN computes the smallest value

MAX computes the largest value

AVG computes the average of the values (equal to mean)

COUNT computes the number of nonmissing values

N computes the number of nonmissing values

NMISS computes the number of missing values

***Usages***
Usage	Description
`PAGE`	creates a new page at each new column value. PAGE is used with the ACROSS, GROUP, or BREAK usages. PAGE is valid only with a report of type TABLE. With other types of reports, PAGE is used like a GROUP usage. The corresponding SAS/GRAPH option for this usage is BY, which creates a new page for each BY value.
`GROUP`	groups data by the values in the column. The corresponding SAS/GRAPH option for this usage is GROUP, which organizes bars and pies into groups by different values of the GROUP variable.
`ACROSS`	groups the report into subgroups across the report. The corresponding SAS/GRAPH option for this usage is ACROSS, which is used to place multiple pies "across" on a page and also is used by the LEGEND statement.
`BREAK`	computes one summary for each column in a LIST report. With other types of reports, BREAK is used like a GROUP usage.
`SUM`	computes the sum of the values. The corresponding SAS/GRAPH option for this usage is SUM, which prints the value of the sum statistic above bars.
`MEAN`	computes the mean of the values. The corresponding SAS/GRAPH option for this usage is MEAN, which is the value of the statistic for the variable being used for calculations.
`MIN`	computes the smallest value
`MAX`	computes the largest value
`AVG`	computes the average of the values (equal to mean)
`COUNT`	computes the number of nonmissing values
`N`	computes the number of nonmissing values
`NMISS`	computes the number of missing values

The following display shows the AIRLINE.MARCH table in the Report Engine window. All of the modifications made in the previous section are in effect; in addition, the report has been further modified so that the report shows totals (SUM usage) for the number of boarded and nonpaying passengers. A forward slash ( /) has been inserted in the column header for the Max No. of boarded passengers so the header breaks after the word Max.

Report Engine Window with AIRLINE.MARCH Table and More Modifications

[IMAGE]

The following display shows the passenger information report grouped by date with the sum of the boarded passengers, the maximum number of boarded passengers, and the sum of the nonpaying passengers. The report has been scrolled forward to show the sums for the boarded and nonpaying columns.

AIRLINE.MARCH Listing Report with More Modifications

[IMAGE]

Chapter Contents
Previous
Next
Top of Page