Hi:
In order to preserve indenting in forum postings, you need to use the [pre] and [/pre] tags around your code and output in order to maintain indenting and spacing, as described in this forum posting:
http://support.sas.com/forums/thread.jspa?messageID=27609毙
Understanding what you want to produce is only half of the equation. The other half of the equation is what your starting point looks like. For example, do you have variables named Jan, Feb and March or do you have a MONTH variable -- similar to what I posted for SASHELP.PRDSALE. What do your input observations look like??? Are DOLLARS SPENT, MONTHS ACTIVE and NUMBER OF TRANSACTION on 1 observation or on multiple observations? It could be that you could use PROC TABULATE for this report, but again, it's hard to say without seeing your INPUT data and a sample of variables from your INPUT data.
Since the SASHELP files are available on every installation, however, you should be able to compare the structure of SASHELP.PRDSALE with the structure of your INPUT data. Did you look at the PROC REPORT code that's been posted? Is there a reason a similar program won't work for your data???
Without knowing what your starting point (your input data) looks like, it is impossible to say whether your data needs to undergo any transformations before you pass it to PROC REPORT. Or whether PROC TABULATE might be a better choice.
But since you haven't posted what your INPUT data looks like, it's very hard to make further comments. (Just curious...what happened to the Average Percent row that you originally posted??)
cynthia