Date: Fri, 9 Nov 2007 16:17:27 -0800
Reply-To: "Pardee, Roy" <pardee.r@GHC.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Pardee, Roy" <pardee.r@GHC.ORG>
Subject: Re: Percentages. Somehow this should be simple. Help!
Content-Type: text/plain; charset="US-ASCII"
If you posted a datastep w/sample data, your closest try w/proc tabulate
& a description of where the results vary from what you want, I bet
you'd get a lot of people working for you...
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ali
Sent: Friday, November 09, 2007 3:51 PM
Subject: Percentages. Somehow this should be simple. Help!
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?