Previous Topic: Suffix Codes

Next Topic: Data Field Suffix Codes


Control Group Suffix Codes

Suffix Code

Description

Used with
Statements

(-)

Causes a line of dashes to be printed after each line of group totals for the field.

BREAK

(AV)

Computes the average value of the field for all records in the control group. This suffix does not work with numeric fields defined as (NV). It is also mutually exclusive with (CT), (DF), (DL), (MN), (MX), (PC), (SD), and (TL).

COMPUTE
LIST

(D)

The field is sorted in descending sequence.

BREAK
SORT

(MN)

Computes the minimum value of the field for all records in the control group. This suffix does not work with numeric fields defined as (NV). It is also mutually exclusive with (AV), (CT), (DF), (DL), (MX), (PC), (SD), and (TL).

COMPUTE
LIST

(MX)

Computes the maximum value of the field for all records in the control group. This suffix does not work with numeric fields defined as (NV). It is also mutually exclusive with (AV), (CT), (DF), (DL), (MN), (PC), (SD), and (TL).

COMPUTE
LIST

(PC)

Computes the record or control group's percentage of the field total. PreSORT totalling is required for successful operation of this suffix code. This suffix does not work with fields defined on a LIST statement that is part of a RANK report, nor does it work with numeric fields defined as (NV). It is also mutually exclusive with (AV), (CT), (DF), (DL), (MN), (MX), (SD), and (TL).

COMPUTE
LIST

(R)

Causes the control group heading to be right-justified.

BREAK

(Sn)

Prints n blank lines after each line of control group totals for the field.

BREAK

(SB)

Suppresses printing totals for this break if there is only one break at the lower level, or in the case of the lower level break, only one record.

BREAK

(SD)

Computes the standard deviation of the field for all records in the control group. This suffix does not work with numeric fields defined as (NV). It is also mutually exclusive with (AV), (CT), (DF), (DL), (MN), (MX), (PC), and (TL).

COMPUTE
LIST

(SK)

Skips to a new page after printing each line of control group totals for a field.

BREAK

(T)

Requests vertical totals for a field after every control group break. The field does not appear in the detail print line.

LIST

(Tn)

Requests vertical totals for a field after control group breaks of n level and higher. n must have a value from 1 to 8.

LIST