replace '.' with ',' in a numeric column

[venka]

Hi

Can any one help with following. (value in 'amt' column should be changed i.e,  '.' should be replaced by ',')

data have; 
name='alpha';amt=100090.23; output;
name='beta';amt=299999.12; output;
run;

data want;
name='alpha';amt='100090,23'; output;
name='beta';amt='299999,12'; output;
run;

Thanks in advance

[Haikuo]

Please check this:

SAS(R) 9.3 Functions and CALL Routines: Reference

[venka]

Thanks, but what I have is a numeric column with a decimal value and translate and tranwrd are useful for character columns.

[PaigeMiller]

You want to assign the COMMAX format to this numeric variable.

[venka]

@PaigeMiller: I just wanted to replace . with , and commax format also inserts period that separates every three digits.

But any ways, I converted the column to char and used translate, it works fine.

[RW9]

Numeric data does not allow commas, slashes, or any other special character other than -0123456789..  If you want to have comma's then you either need to apply a format - such as PaigeMiller has suggested - which basically applies a viewing format to the data which would remain unchanged, or convert the numeric data into a text field and then use textual replace functions on it.

data want;

     set have;

     length new_amt $20;

     new_amt=tranwrd(put(amt,best.),".",",");

run;

[Ksharp · Accepted solution]

Add NUMXw.d format . You must come from somewhere of Euro ?

data have; 

name='alpha';amt=100090.23; output;

name='beta';amt=299999.12; output;

format amt numx12.2;

run;

Xia Keshan

[venka]

Thanks! thats perfect and also correct guess.