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!
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;
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
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.