03-03-2017 02:51 PM
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.
03-03-2017 03:03 PM
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.
03-03-2017 03:07 PM
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.
Need further help from the community? Please ask a new question.