Previous Topic: Format

Next Topic: Sample Usage


Parameters

IF...THEN SORTKEY

IF THEN instructions function in the same way as in the COMPUTE statement. Use AND and OR if necessary to establish multiple conditions. For example:

IF OP CODE = 'R' AND DIV CODE = 1915 THEN
  SORTKEY = AUDIT RERUNS

This example checks two data fields before accepting a record for inclusion in the AUDIT RERUNS exception report. Refer to the description of the SELECT statement for rules about the syntax of conditional tests. Note that the equal sign (=) and the EQ characters can be used interchangeably.

The THEN keyword must be followed by SORTKEY=report-name.

report-name

contains up to 30 characters that are used for sorting and must be unique for each report.

The name must contain only the letters A through Z and the digits 0 through 9. Special characters are not allowed.