https://communities.sas.com/t5/SAS-Procedures/Tabulate/m-p/71370#M20603 How can one achieve a layout like this using proc tabulate? if not tabulate than what other procedure can I use.<BR /> Hope the layout is preserved...basically I need a cross tab, grade in rows with total, then gender and year in columns, with a year on year growth, and a column total.<BR /> <BR /> Male Female Total <BR /> 2005 2006 %incr 2005 2006 %incr 2005 2006 %incr<BR /> Grade<BR /> 1 10 20 100% 10 20 100% 20 40 100% <BR /> 2 10 20 100% 10 20 100% 20 40 100%<BR /> Total 20 40 100% 20 40 100% 40 80 100%<BR /> <BR /> Brendan Tue, 27 Jan 2009 09:45:16 GMT deleted_user 2009-01-27T09:45:16Z https://communities.sas.com/t5/SAS-Procedures/Tabulate/m-p/71370#M20603 How can one achieve a layout like this using proc tabulate? if not tabulate than what other procedure can I use.<BR /> Hope the layout is preserved...basically I need a cross tab, grade in rows with total, then gender and year in columns, with a year on year growth, and a column total.<BR /> <BR /> Male Female Total <BR /> 2005 2006 %incr 2005 2006 %incr 2005 2006 %incr<BR /> Grade<BR /> 1 10 20 100% 10 20 100% 20 40 100% <BR /> 2 10 20 100% 10 20 100% 20 40 100%<BR /> Total 20 40 100% 20 40 100% 40 80 100%<BR /> <BR /> Brendan Tue, 27 Jan 2009 09:45:16 GMT https://communities.sas.com/t5/SAS-Procedures/Tabulate/m-p/71370#M20603 deleted_user 2009-01-27T09:45:16Z https://communities.sas.com/t5/SAS-Procedures/Tabulate/m-p/71371#M20604 have a look at denominator definitions.<BR /> One variation allows you to define an analysis variable as the denominator. Then you achieve ratios.<BR /> <BR /> PeterC Tue, 27 Jan 2009 12:11:30 GMT https://communities.sas.com/t5/SAS-Procedures/Tabulate/m-p/71371#M20604 deleted_user 2009-01-27T12:11:30Z