format in proc frequency

[deega]

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 ?

[anoopmohandas7]

Deega,

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

Good Luck.

[deega]

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

[anoopmohandas7]

Glad to know.

[Kalind_Patel]

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

[Reeza]

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