topic Re: replace '.' with ',' in a numeric column in SAS Procedures

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

venka — Tue, 03 Feb 2015 14:43:26 GMT

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

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

Haikuo — Tue, 03 Feb 2015 14:45:38 GMT

Please check this:

SAS(R) 9.3 Functions and CALL Routines: Reference

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

venka — Tue, 03 Feb 2015 14:50:21 GMT

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

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

PaigeMiller — Tue, 03 Feb 2015 14:52:00 GMT

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

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

venka — Tue, 03 Feb 2015 14:57:23 GMT

@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.

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

RW9 — Tue, 03 Feb 2015 14:58:15 GMT

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;

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

Ksharp — Wed, 04 Feb 2015 07:27:07 GMT

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

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

venka — Wed, 04 Feb 2015 10:10:36 GMT

Thanks! thats perfect and also correct guess.