Removes embedded characters.
Category: |
Numeric
|
Alias: |
DOLLARw.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 decimal points, the d
value is ignored. This argument is optional.
The COMMAw.d informat reads numeric values and removes embedded commas,
blanks, dollar signs, percent signs, dashes, and close parentheses
from the input data. The COMMAw.d informat converts an open parenthesis at the beginning of
a field to a minus sign.
The
COMMAw.d informat operates like the
COMMAXw.d informat,
but it reverses the roles of the decimal point and the comma. This convention
is common in European countries.
input @1 x comma10.;
Data Line |
Results |
----+----1----+
|
|
$1,000,000
|
1000000
|
(500)
|
-500
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.