Numeric Edit Format Characters

Table 56. Numeric Edit Format Characters

Character

Description

8

Digit, zero fill to the right of the decimal point, trim leading blanks (left justify the number).

9

Digit, zero fill to the right of the decimal point, space fill to the left.

0

Digit, zero fill to the left.

$

Dollar sign, optionally floats to the right.

B

Treated as a “9”, but if a value is zero, the field is converted to blanks.

C

Entered at the end of the mask, causes the comma and period characters to be transposed when the edit occurs. This is to support monetary values where periods delimit thousands and commas delimit decimals. (Example: 1.234,56).

E

Scientific format. The number of 9s after the decimal point determines the number of significant digits displayed. The “E” can be upper or lower case; the display follows the case of the mask.

V

Implied decimal point.

MI

Entered at the end of the mask, causes a minus to display at the right of the number.

PR

Entered at the end of the mask, causes angle brackets (< >) to display around the number if the number is negative.

PS

Entered at the end of the mask, causes parentheses to display around the number if the number is negative.

PF

Entered at the end of the mask, causes floating parentheses to display around the number if the number is negative.

NA

Entered at the end of the mask, causes “N/A” to display if the numeric column variable is null. The case of N/A follows that of the mask.

NU

Entered at the end of the mask, causes blanks to display if the numeric column variable is null.

.

Decimal point.

,

Comma.

Note:

Characters other than those listed in Table 56 are illegal for numeric edit masks and cause errors during processing.