Help using Base SAS procedures

proc freq format output

Reply
Frequent Contributor
Posts: 104

proc freq format output

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

Super User
Posts: 17,840

Re: proc freq format output

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

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

Super User
Posts: 10,508

Re: proc freq format output

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.

Super User
Posts: 9,682

Re: proc freq format output

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

Ask a Question
Discussion stats
  • 3 replies
  • 250 views
  • 0 likes
  • 4 in conversation