Multiple-Line Substitution

Many commands, such as END, must appear on a separate line in a report request. To include such a command in a LET definition, place a number sign (#) and a space before the command to indicate a new line. This allows you to substitute one word for several lines of code.

Example: Making Multiple-Line Substitutions

This LET command uses the number sign and a space to indicate that a new line is required for the END command:

LET HOLDREP = ON TABLE HOLD # END

The following request

TABLE FILE EMPLOYEE
SUM AVE.GROSS BY EMP_ID BY PAY_DATE
HOLDREP

is translated as:

TABLE FILE EMPLOYEE
SUM AVE.GROSS BY EMP_ID BY PAY_DATE
ON TABLE HOLD
END