Date: Fri, 9 Nov 2007 15:50:55 -0800
Reply-To: Ali G <Alistair.Gordon@NEWTYNE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ali G <Alistair.Gordon@NEWTYNE.COM>
Subject: Percentages. Somehow this should be simple. Help!
Content-Type: text/plain; charset="iso-8859-1"
I want to create a tabular report. Across the top are weeks, and
under each week are three columns; previewed, booked and then a
percentage which is derived as booked/previewed.
The rows are region and branch, and I'd like to provide summary totals
for each region and overall totals too. The subtotals and totals will
simply be the sum of previewed and booked. And I'd like to calculate
percentages for totals and subtotals also.
It seems to me that I cannot render this report using proc tabulate,
summary, means or report. I seem faced with having to calculate the
percentages prior to actually producing the report otherwise the
report either gets the percentages wrong (for some rows) or cannot
calculate the percentages at all. To me SAS only seems to be able to
automatically calc the percentages for one variable compared to a
report total or subtotal; not one var compared to another.
Am I missing something?