https://communities.sas.com/t5/ODS-and-Base-Reporting/tabulate-pctn/m-p/1764#M784 I'm trying to get % for each drg using the 'admitsrc'<BR /> subtotal as the denominator.<BR /> <BR /> proc tabulate data=final;<BR /> class fyr admitsrc drg;<BR /> var pats;<BR /> table admitsrc*(drg all) ,fyr*(pats*sum*f=5. pctn ); <BR /> run;<BR /> <BR /> Thanks. Tue, 14 Nov 2006 20:57:17 GMT uabcms 2006-11-14T20:57:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/tabulate-pctn/m-p/1764#M784 I'm trying to get % for each drg using the 'admitsrc'<BR /> subtotal as the denominator.<BR /> <BR /> proc tabulate data=final;<BR /> class fyr admitsrc drg;<BR /> var pats;<BR /> table admitsrc*(drg all) ,fyr*(pats*sum*f=5. pctn ); <BR /> run;<BR /> <BR /> Thanks. Tue, 14 Nov 2006 20:57:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/tabulate-pctn/m-p/1764#M784 uabcms 2006-11-14T20:57:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/tabulate-pctn/m-p/1765#M785 Try the following PROC TABULATE code:<BR /> <BR /> proc tabulate data=final;<BR /> class fyr admitsrc drg;<BR /> var pats;<BR /> table admitsrc*(drg all) ,fyr*(pats*sum pctn<DRG all="">); <BR /> run;<BR /> <BR /> If this does not answer your question, I would suggest opening a tracking number with Technical Support by sending email to support@sas.com with your code, a sample of the output, and an explanation of the percentages you are trying to get.</DRG> Wed, 15 Nov 2006 12:49:43 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/tabulate-pctn/m-p/1765#M785 Kathryn_SAS 2006-11-15T12:49:43Z