topic Re: format in proc frequency in SAS Programming

format in proc frequency

deega — Thu, 15 Dec 2016 05:45:22 GMT

Hi All,

I am running the following code:

proc freq data = filename;
table A*B/ nocum nocol norow out = datasetA;;
weight C;
run;

Now the value in column C is too big and the summation is making it much bigger , around 12 digit number so in the output I am getting the values like 2.239E9. Is there a way to format two way table ?

Re: format in proc frequency

anoopmohandas7 — Thu, 15 Dec 2016 06:36:58 GMT

Deega,

Try using a proc template. Use the below as reference.

Good Luck.

Re: format in proc frequency

Kalind_Patel — Thu, 15 Dec 2016 06:39:33 GMT

Hi @deega;

Have you tried to use proc template for your proc freq output ?

i think that can solve your problem,

Here is the link for more info :https://support.sas.com/resources/papers/freq92.pdf

Re: format in proc frequency

deega — Thu, 15 Dec 2016 06:44:20 GMT

Thanks...
I saw this document but was little confused... It solved my problem

Re: format in proc frequency

anoopmohandas7 — Thu, 15 Dec 2016 06:49:43 GMT

Glad to know.

Re: format in proc frequency

Reeza — Thu, 15 Dec 2016 07:05:44 GMT

An alternative is to use PROC TABULATE. You have more control of output.