Help using Base SAS procedures

How to get calculated percent of row totals on each By-Group subtotals row and the grand total row.

Reply
Contributor
Posts: 61

How to get calculated percent of row totals on each By-Group subtotals row and the grand total row.

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.

Attachment
Ask a Question
Discussion stats
  • 0 replies
  • 219 views
  • 0 likes
  • 1 in conversation