Hi Community,
I have outputted the data set named “Source_Data_Bank” using following proc summary procedure.
I need the output file’s data to be appeared with no decimals and with 1000 separators (1,000,000)
proc summary data=vtemp nway missing maxdec=0; /* maxdec not responds */
format date date9.;
class date;
var Current One_to_30 Thirty_to_60 Sixty_to_90 Ninety_plus NPNA write_off;
output out=/*a.*/Source_Data_Bank(drop=_:)
sum=;
run;
Could any one help me?
Thanks
Mirisage
You might be pleasantly surprised what happens when you add:
format Current One_to_30 Thirty_to_60 Sixty_to_90 Ninety_plus NPNA write_off comma15.0;
to the proc summary code. The COMMAw.d format accepts w values up to 32, so adjust the 15 above as needed.
Not directly, you need a second step to apply formats to the data, or use proc tabulate instead.
EDIT: You could go and change the template but that seems complicated when there are other solutions.
You might be pleasantly surprised what happens when you add:
format Current One_to_30 Thirty_to_60 Sixty_to_90 Ninety_plus NPNA write_off comma15.0;
to the proc summary code. The COMMAw.d format accepts w values up to 32, so adjust the 15 above as needed.
Hi ballardw,
Actually it was a pleasent surprise!
It exactly worked the way I wanted.
Thank you so much for your help.
Hi Reeza,
Thank you for your help too.
Warm regards
Mirisage
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.