proc freq format output

[sophia_SAS]

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

[Reeza]

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

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

[ballardw]

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.

[Ksharp]

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