Previous Page | Next Page

Informats

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
Syntax Description
Details
Comparisons
Examples

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, dashes, 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.


Examples

input @1 x commax10.; 

Data Line Results
----+----1----+

$1.000.000
1000000
1.234,56
1234.56
(500)
-500

Previous Page | Next Page | Top of Page