DATA Step, Macro, Functions and more

SAS numerical formats

Reply
Contributor
Posts: 26

SAS numerical formats

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 Smiley Happy

Super User
Super User
Posts: 7,035

Re: SAS numerical formats

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

See:  Using a Function to Format Values

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);

Ask a Question
Discussion stats
  • 1 reply
  • 714 views
  • 0 likes
  • 2 in conversation