Previous Topic: Control Group Suffix Codes

Next Topic: Date and Time Field Suffix Codes


Data Field Suffix Codes

Suffix Code

Description

Used with
Statements

(.n)

Indicates the field has n decimal positions, or if the field is hexadecimal, defines the bit position. When used with a field in a LIST statement, the printed data for the field is truncated to the specified decimal position.

COMPUTE
DECODE
DEFINE
LIST

(n)

Specifies the length of a field (n). Valid values for n are: 1-16 for numeric fields; 1-255 for character fields.

COMPUTE
DECODE
DEFINE

(x,y)

Used to access a subfield within a character field. Specify x as the first position of the subfield and y as the number of positions. This suffix must not be used with numeric or date fields.

ANY

(A)

Ranks records in ascending order by the specified field.

RANK

(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

(B)

Specifies that a field contains binary data only.

COMPUTE
DECODE
DEFINE

(C)

Specifies that a field contains EBCDIC character data only.

COMPUTE
DECODE
DEFINE

(D)

The field is sorted in descending sequence.

BREAK
SORT

(DD/MM/YY)

Specifies that a date field must be a character field with an internal format of DD/MM/YY.

COMPUTE
DECODE
DEFINE

(DDMMYY)

Specifies that a date field must be a numeric, packed, or character field with an internal format of DDMMYY.

COMPUTE
DECODE
DEFINE

(Gn)

The field prints in plot format using its default specifications or as described in a corresponding PLOT Gn statement. Specify n from 1 to 6.

LIST

(H)

Specifies that a field contains hexadecimal data only.

COMPUTE
DECODE
DEFINE

(K)

Indicates that a field is maintained by the user CA JARS Wizard does not automatically reset it.

DEFINE
COMPUTE

(MM/DD/YY)

Specifies that a date field must be a character field with an internal format of MM/DD/YY.

COMPUTE
DECODE
DEFINE

(MMDDYY)

Specifies that a date field must be a numeric, packed, or character field with an internal format of MMDDYY.

COMPUTE
DECODE
DEFINE

(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

(N)

Specifies that a field contains numeric, zoned decimal data only.

COMPUTE
DECODE
DEFINE

(NOSP)

Indicates that the field cannot be split into time slices by the Interval Chopper. This is the default for all fields.

COMPUTE
DECODE
DEFINE

(P)

Specifies that a field contains numeric, packed decimal data only.

COMPUTE
DECODE
DEFINE

(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

(SD)

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

COMPUTE
LIST

(SP)

Indicates that the field can be split into time slices by the Interval Chopper. Any user-created fields MUST have an (SP) suffix to be printed in an Interval Chopper report.

COMPUTE
DECODE
DEFINE

(ST)

Resets print options for the specified time field. All time values for this field are expressed in seconds.

COMPUTE
DECODE
DEFINE
LIST

(TL)

Computes the total value of the field. PreSORT totalling is required for successful operation of this suffix code. 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 (SD).

COMPUTE
LIST

(YY/MM/DD)

Specifies that a date field must be a character field with an internal format of YY/MM/DD.

COMPUTE
DECODE
DEFINE

(YYDDD)

Specifies that a date field must be a numeric, packed or character field with an internal format of YYDDD (Julian date).

COMPUTE
DECODE
DEFINE

(YYMMDD)

Specifies that a date field must be a numeric, packed, or character field with an internal format of YYMMDD.

COMPUTE
DECODE
DEFINE