topic Re: Increase Decimal Places Shown for Percent of Row Frequency in SAS Programming

Increase Decimal Places Shown for Percent of Row Frequency

UserID437122 — Wed, 16 Nov 2022 20:22:08 GMT

Hello,

I'm trying to add decimal places for the output shown for proc freq using ODS code. I am interested in the percent of row frequency. I can get the ODS code to work for overall percent but not for the percent of row frequency. I've tried to include row_pct 8.4 but I get an error code that the variable 'ROW_PCT not found in data set WORK.INDTABLE.'

ods trace on;
proc freq data=county;
table gender*abuse / chisq expected;
format gender gender. abuse abuse.;
ods output CrossTabFreqs=IndTable;
run;
proc print data=IndTable label;
format percent 8.4
row_pct 8.4;
run;

Any advice is greatly appreciated, thanks.

Re: Increase Decimal Places Shown for Percent of Row Frequency

Tom — Wed, 16 Nov 2022 22:18:51 GMT

Why not use the variable's name? If you remove the LABEL option from the PROC PRINT step you can see the actual variable name. ROWPERCENT

proc format ;
  value agegp low - 12 = '<=12' other='>12';
run;
proc freq data=sashelp.class;
  table sex*age / chisq expected;
  format age agegp.;
ods output CrossTabFreqs=IndTable;
run;
proc print data=IndTable label;
  format percent rowpercent colpercent 8.4 ;
run;

Re: Increase Decimal Places Shown for Percent of Row Frequency

UserID437122 — Wed, 16 Nov 2022 22:51:37 GMT

That worked great, thank you!