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
|
-
w
-
specifies the width of the input field.
-
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.
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.
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.
input @1 x commax10.;
|
Data Line |
Results |
----+----1----+
|
|
$1.000.000
|
1000000
|
1.234,56
|
1234.56
|
(500)
|
-500
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
