SAS numerical formats

Shirin — Thu, 28 Nov 2013 15:52:47 GMT

Hello,

I am using the SAS comma12. format. However some values have decimal points and some don't.

I would like to see two decimal places for those who have decimals and no demilas for those who don't.

For example, I would like to see:

12,987.23

365

45,525

145.60

If I change the format to comma12.2 then I get values like 365.00 which I don't want, and if I keep it as comma12. then I lose the decimals!

Any help would be greatly appreciated.

Thank you

Re: SAS numerical formats

Tom — Thu, 28 Nov 2013 16:52:33 GMT

If you really want to do that I think you probably need to write your function.

Or you could use code to build your own string in a datastep and print that instead.

if num = int(num) then text=put(num,comma12.);

else text=put(num,comma12.2);