Looking for a way to format the following output so that the column percents show up with zero decimal places:
proc freq data = CombineScoredTemp;
tables _node_ * Bin_SLR
/nopercent norow nofreq;
run;
Of course I could copy & paste it into Excel. Then format it. Then I would want more decimal places.
Also, is there a way to output these column percents so that a % shows up with the numbers?
Thank you very much in advance.
Consider using Proc TABULATE insted which gives you many more formating options than Proc FREQ.
Compare the reports produced by the following two sample codes:
1. Using Proc FREQ:
proc freq data=sashelp.class;
tables age*sex / nopercent norow nofreq;
run;
2. Using Proc FORMAT ans Proc TABULATE:
proc format;
picture pctfmt low-high='009.99 %';
run;
proc tabulate data=sashelp.class format=10.;
class age sex;
table age all , sex*colpctn*F=pctfmt10.;
keylabel all='Total' colpctn='Col Pct';
run;
CTorres
Consider using Proc TABULATE insted which gives you many more formating options than Proc FREQ.
Compare the reports produced by the following two sample codes:
1. Using Proc FREQ:
proc freq data=sashelp.class;
tables age*sex / nopercent norow nofreq;
run;
2. Using Proc FORMAT ans Proc TABULATE:
proc format;
picture pctfmt low-high='009.99 %';
run;
proc tabulate data=sashelp.class format=10.;
class age sex;
table age all , sex*colpctn*F=pctfmt10.;
keylabel all='Total' colpctn='Col Pct';
run;
CTorres
Thank you very much for introducing me to proc tabulate.
The website that has proven to be most helpful is:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.