COMMAXw.d Informat

Removes embedded periods, blanks, dollar signs, percent signs, dashes, and closing parenthesis from the input data. An open parenthesis at the beginning of a field is converted to a minus sign. The COMMAX informat reverses the roles of the decimal point and the comma.
Category: Numeric
Alias: DOLLARXw.d

Syntax

COMMAXw.d

Syntax Description

w
specifies the width of the input field.
Default:1
Range:1−32
d
specifies the power of 10 by which to divide the value. If the data contain a comma, which represents a decimal point, the d value is ignored. This argument is optional.
Range:0−31

Details

The COMMAXw.d informat reads numeric values and removes embedded periods, blanks, dollar signs, percent signs, hyphens, and close parentheses from the input data. The COMMAXw.d informat converts an open parenthesis at the beginning of a field to a minus sign.

Comparisons

The COMMAXw.d informat operates like the COMMAw.d informat, but it reverses the roles of the decimal point and the comma. This convention is common in European countries.

Example

input @1 x commax10.; 
Data Line
Result
----+----1----+
$1.000.000
1000000
1.234,56
1234.56
(500)
-500