topic Proc Tabulate percentage column in ODS and Base Reporting

Proc Tabulate percentage column

mary_mcneill — Fri, 03 Mar 2017 19:51:14 GMT

Hello,

I am trying to display percentages by year in a multi-dimensional table. Everytime I try to use the pctn I get the percent for the entire column, but I would like to get the percent Yes/No by year. Here is what I would like to see:

2012 2013 2014

Co-morbidity Co-morbidity Co-morbidity

No % Yes % No % Yes % No % Yes %

Condition: 900 90 100 10 550 68.8 250 31.3

The way I have it now it is calculating the percent for the entire row for all years.

Thanks!

Re: Proc Tabulate percentage column

collinelliot — Fri, 03 Mar 2017 20:03:44 GMT

Without seeing the data, it's difficult to help, but if rowpct or colpct won't do what you want, this is likely a case where you're going to have to use a custom denominator for calculating percentages.

https://support.sas.com/resources/papers/proceedings13/134-2013.pdf

Re: Proc Tabulate percentage column

ballardw — Fri, 03 Mar 2017 20:07:05 GMT

If you share the proc tabulate code we may be able to provide some more targetted hints. Example data and desired output would be helpful as well.

Re: Proc Tabulate percentage column

mary_mcneill — Fri, 03 Mar 2017 20:24:52 GMT

I figured it out... but here is how I did it if anyone else is wondering 🙂

table condition, year *(comorb*(N pctn<comorb>*f=pct.)) all;

Re: Proc Tabulate percentage column

Reeza — Fri, 03 Mar 2017 20:34:15 GMT

@mary_mcneill

Please mark the question as answered.

Re: Proc Tabulate percentage column

mary_mcneill — Fri, 03 Mar 2017 21:21:37 GMT

How do I do that? I am new to the forum 🙂