topic Re: comma in SAS Programming

comma

mjack — Thu, 31 Jul 2014 08:48:19 GMT

Hi,

need help.

I need decimals to be replaced by comma in numbers.

for e,g, 145.3 as 145,30

33428778 as 33428778,00

how to code this?

RW9 — Thu, 31 Jul 2014 08:55:03 GMT

Hi,

Apply a format comma10.;

data want;

attrib b format=comma10.;

a=1234567;

b=a;

run;

mjack — Thu, 31 Jul 2014 09:12:54 GMT

Hi ,

My requirement is to have decimal replaced with comma.

COMMA10, will give comma after every 3 digits but my requirement is only one comma per number.. that is..,

33428778 shd be 33428778,00 and not 33,428,778

similarly

145.7 shd be 145,70

Scott_Mitchell — Thu, 31 Jul 2014 09:19:23 GMT

DATA WANT;

ATTRIB NEW FORMAT=NUMX10.2;

OLD=145.3;

NEW=OLD;

RUN;

mjack — Thu, 31 Jul 2014 09:41:18 GMT

yes , numx10.2 works thanks...