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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.