Commands › TABulate Command-Produce Tabular Reports

TABulate Command-Produce Tabular Reports

The TAB command produces tabular reports. The variables you specify with the TAB command determine the columns in your report and the order in which they appear.

The operands you specify determine:

• How the report is organized: by time, by classes of or individual identifiers (such as transactions, terminals, or users), or by the relationship between identifiers
• How the report is sorted
• The column headings that appear in the report

This command has the following syntax:

TAB [period] [idoption[(identifiers)]] variable [options]
 [HDR1(text)] [HDR2(text)] [SORT order] [FOR n] [AND,
 [TOP n]
 [BOTTOM n]
 variable [options] [HDR1(text)] [HDR2(text)]] [AND,...]

period

Sets the first column in the report to one of the following:

• DATETIME - Display the date and time
• DATE - Display the date
• TIME - Display the time
• DAY - Display the day (MONDAY, TUESDAY, and so on)

idoption(identifiers)

Includes any ID option that is valid for the variable, specified with or without identifiers. Specifying this operand organizes the resulting report by the specified ID option and limited to the identifiers specified by identifiers. You can specify multiple ID options.

The identifiers are listed either:

• Beginning in the first column (if you did not specify a time period as the first column) or
• Beginning in the second column

variable

Includes any Report Writer variable.

options

Specifies any valid variable options or ID options. Each ID option you specify must include at least one identifier.

HDR1(text)

Overrides the default top heading for a column. Each column has two default eight-character lines. Replace text with the new column heading. To remove the header, replace text with a null string, as in HDR1( ).

HDR2(text)

Overrides the default bottom heading for a column. Replace text with the new column heading. To remove the header, replace text with a null string, as in HDR2( ).

SORT order

Sorts the report. Replace order with one of the following:

• (Default) DESCENDING

  Sorts variables in descending order. The order starts with the variable specified with the SORT operand, and, when the value is the same for two entries, from left to right.

• ASCENDING

  Sorts variables in ascending order. The order starts with the variable specified with the SORT operand, and, when the value is the same for two entries, from left to right.

• ALPHA

  Sorts variables in alphanumeric order with respect to the specified identifier; for example, by transaction or terminal.

You can use SORT only if you organize the report by identifier; for example, by transaction. If you organize the report by time, then it is already sorted.

FOR n

For Reports Organized by Identifier and Time or Date: Limits your reports to the n identifiers in each time period that would appear first in the report, where n is an integer. For reports sorted in descending order, these reports are the n most active identifiers. For reports sorted in ascending order, these reports are the n least active identifiers.

For Reports Organized by Time or Date: Limits your reports to the n times or dates with the highest values for the first variable specified. For reports sorted by a variable in descending order, these reports are the n times or dates with the highest value for that variable. For reports sorted by a variable in ascending order, these reports are the n times or dates with the lowest value for that variable.

TOP n

Limits reports organized by identifier to the n identifiers with the highest values for the first variable specified, where n is an integer. Unlike the FOR operand, the TOP operand tests each record as it is read and discards records that do not qualify, saving storage.

The TOP operand is appropriate for ID options with many unique identifiers, such as TRANNUM.

BOTTOM n

Identical to the TOP operand except it prints the n identifiers with the lowest values for the first variable specified.

AND,

Signals that another variable is being specified. The comma after AND lets you continue to the next line.

Examples: TAB Command

Create a tabular report organized by date and time that shows the transaction use and average transaction lifetime for all transactions each hour:

TAB DATETIME TRAN USE    AND,
             TRAN LIFE
   EACH HOUR
END
RUN

Create a tabular report organized by date and time that shows the five hours with the highest average transaction lifetime:

TAB DATETIME TRANID TRAN LIFE FOR 5
  EACH HOUR
END
RUN

More information:

Tabular Reports