10-01-2013 07:58 PM
Can anyone suggest how I can get a calculated row percent of each by-group subtotal row and the grand total row percent? I used proc summary to get the individual area % calculated and that displays perfectly on the output, but the roll-up to region subtotals need $ calculated as well.
I am using WindowsXP operating system and SAS 9.3, I am using PROC REPORT and ODS TAGSETS.ExcelXP to create a tabular report in Excel 2007 spreadsheet, by region and area of my company's organization hierarchy.
My sample code, the report itself , and the data file are attached below.