Chapter Contents

Previous

Next
COMMAXw.d

COMMAXw.d



Removes embedded characters

Category: Numeric


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
optionally 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.
Range: 0-31


Details

The COMMAXw.d informat reads numeric values and removes embedded periods, blanks, dollar signs, percent signs, dashes, and right parentheses from the input data. The COMMAXw.d informat converts a left 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 Lines Results
----+----1----+

$1.000.000
1000000
(500)
-500


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.