topic Re: Is there any method to control decimals and introduce 1000 separators in “proc summary output” ? in SAS Procedures

Is there any method to control decimals and introduce 1000 separators in “proc summary output” ?

Mirisage — Thu, 30 Aug 2012 17:57:54 GMT

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

Reeza — Thu, 30 Aug 2012 18:15:27 GMT

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.

ballardw — Thu, 30 Aug 2012 19:24:02 GMT

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.

Mirisage — Sun, 02 Sep 2012 19:15:34 GMT

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