topic Re: proc freq format output in SAS Procedures

proc freq format output

sophia_SAS — Fri, 23 Jan 2015 18:44:16 GMT

Hi SAS community,

I would like to format the proc format output. How do I get SAS to display the percent values rounded to 1 decimal? Can I add custom formats as well, specifically parentheses around the percent value? For example, ColPer = 55.25. I would like the output to read (55.3).

Thanks!eq

Re: proc freq format output

Reeza — Fri, 23 Jan 2015 18:48:45 GMT

Look into proc tabulate instead and then the answer is yes.

You can with Proc Freq, but its much more difficult.

Re: proc freq format output

ballardw — Fri, 23 Jan 2015 19:08:00 GMT

Look in

https://communities.sas.com/thread/64711

for similar discussion.

There is some difference whether you are doing one-way or cross-tabs as to approach if you must use Freq.

Tabulate or possibly Proc report may be better bets though.

Re: proc freq format output

Ksharp — Sat, 24 Jan 2015 08:17:12 GMT

proc format;
picture fmt
 low-high='09.9)' (prefix='(') ;
run;
proc freq data=sashelp.class noprint;
table sex/out=want;
run;
data want;
 set want;
 format PERCENT fmt8.;
run;
proc print;run;

Xia Keshan