Generating Statistics (COUNT, SUM, and STAT)

The COUNT, SUM, and STAT commands generate statistics for the data in a specified file, and produce a short summary rather than a formatted listing of the data.

These commands all permit the use of selection expressions, but none of the modifiers used to format reports are applicable. Because the COUNT, SUM, and STAT commands produce only one or two lines of data, there is no need to specify a heading, footing, double spacing, or any other formatting for the report.

The statistics commands automatically include all data in MultiValued attributes in their calculations.

The following topics are presented in this section:

Counting File Items

Totalling a Numeric Attribute

Generating Statistics for a Numeric Attribute

See Also

Using INFO/ACCESS Commands for Special Processing

Printing Labels

Copying Items to and from Backup Media

Restructuring File Items