How can one achieve a layout like this using proc tabulate? if not tabulate than what other procedure can I use.
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.
Male Female Total
2005 2006 %incr 2005 2006 %incr 2005 2006 %incr
Grade
1 10 20 100% 10 20 100% 20 40 100%
2 10 20 100% 10 20 100% 20 40 100%
Total 20 40 100% 20 40 100% 40 80 100%
Brendan