DATA Step, Macro, Functions and more

format in proc frequency

Reply
Contributor
Posts: 71

format in proc frequency

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 ?

 
Contributor
Posts: 44

Re: format in proc frequency

Deega,

 

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

Good Luck.

 

Screen Shot 2016-12-14 at 22.35.37.png

Contributor
Posts: 71

Re: format in proc frequency

Posted in reply to anoopmohandas7
Thanks...
I saw this document but was little confused... It solved my problem
Contributor
Posts: 44

Re: format in proc frequency

Glad to know.
Frequent Contributor
Posts: 96

Re: format in proc frequency

[ Edited ]

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

 

 

Super User
Posts: 19,822

Re: format in proc frequency

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

Ask a Question
Discussion stats
  • 5 replies
  • 241 views
  • 4 likes
  • 4 in conversation