topic Re: proc freq with totpct not print percent. Why? in SAS Programming

proc freq with totpct not print percent. Why?

mhollifi — Tue, 06 Feb 2018 20:47:18 GMT

I have SAS, proc freq with totpct. But total percent doesn't show on the table. Why?

And how to print total percent? There is no error message.

Thank you for your help

proc freq data= us;
tables peeduca * natvty / totpct nocol nofreq nopercent out = out outpct;
format peeduca peeduca. ;
run;
title "Educational Breakdown(percentage of U.S. labor force)";

Re: proc freq with totpct not print percent. Why?

Rick_SAS — Tue, 06 Feb 2018 21:13:35 GMT

Because you also specified the NOPERCENT option.

Re: proc freq with totpct not print percent. Why?

mhollifi — Tue, 06 Feb 2018 21:23:45 GMT

If I don't specify nopercent option, it output percent in all cells. I want only row percent in all cells including the row "total".

Re: proc freq with totpct not print percent. Why?

ballardw — Tue, 06 Feb 2018 21:56:41 GMT

@mhollifi wrote:

I have SAS, proc freq with totpct. But total percent doesn't show on the table. Why?

And how to print total percent? There is no error message.

Thank you for your help

proc freq data= us;
tables peeduca * natvty / totpct nocol nofreq nopercent out = out outpct;
format peeduca peeduca. ;
run;
title "Educational Breakdown(percentage of U.S. labor force)";

May be you should show what your desired table looks like and not one that is not what you want.

Re: proc freq with totpct not print percent. Why?

mhollifi — Tue, 06 Feb 2018 22:10:25 GMT

Please look at the Total line. I want have percent not frequency in the line. thank you.