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
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);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.