EUROXw.d Informat

Reads numeric values and removes embedded characters in European currency.

Category:

Numeric

Syntax

EUROXw.d

Syntax Description

w: specifies the width of the input field.

Default:6

Range:1–32

d: specifies the power of 10 by which to divide the value. If the data contains a comma, which represents a decimal point, the d value is ignored.

Default:0

Range:0–31

Details

The EUROXw.d informat reads numeric values and removes embedded euro symbols (E), periods, blanks, percent signs, dashes, and close parentheses from the input data. A comma is assumed to be a separator between the whole number and the decimal portion. The EUROXw.d informat converts an open parenthesis at the beginning of a field to a minus sign.

Comparisons

The EUROXw.d informat is similar to the EUROw.d informat, but EUROw.d reverses the roles of the comma and the decimal point. This convention is common in English-speaking countries.
If no commas or periods appear in the input, the EUROXw.d and the EUROw.d informats are interchangeable.

Example

The following table shows input values for currency in euros, the SAS statements that are applied, and the results.

data _null_;    
   input x eurox10.;    
   put x=;   
   datalines; 
E1 
E1.23 
1.23 
1,234.56
; run;
SAS Log:
7       input x eurox10.;
8       put x=;
9       datalines;
x=1
x=123
x=123
x=1.23456

Values	Statements	Results
		----+----1----2
E1	input x eurox10.; put x;	1
E1.23	input x eurox10.; put x;	123
1.23	input x eurox10.; put x;	123
1,234.56	input x eurox10.; put x;	1.23456

EUROXw.d Informat

Syntax

Syntax Description

Details

Comparisons

Example

See Also