Hi:
You have left out some valuable information. Do you have detail data? Do you already have summarized data? The presence of variables TOTAL_RXN and TOTAL_RX imply that your data is already summarized.
When you say you want to
"group the product by terri_state ,total_rxn,total_rx,district "
do you mean that you want a report that is summarized at different levels? Do you want to have a summary line for every unique PRODUCT and TERRI_STATE combination? or do you want to see ALL the products for one TERRI_STATE???
This is an instance where some dummy data would be useful to see, as well as an example of what you expect the output report to look like. Also, some idea of what you've already tried -- PROC MEANS or PROC PRINT??? Do you think you need PROC TABULATE or PROC REPORT??? How did you create the TOTAL_RXN and TOTAL_RX columns??? You give us a DATE format, but you only have a WEEK variable -- generally a WEEK variable will range from 1 to 52. Or, is your WEEK variable actually a DATE variable????
You also don't say whether you have all the data (current month and previous month) in ONE file/dataset or whether current month is in ONE file/dataset and previous month is in a separate file/dataset. Also, on the report -- do you envision one page for the the current month and a second page for the previous month, or do you want to see the current month information and the previous month information on the same report row????
Also useful to know, since you're posting in the ODS forum, is information about your destination of choice -- do you want an HTML report, and RTF report, a PDF report????
If you are going to post your code or a sample of your data, this is a very handy forum posting that explains how to post questions and still maintain the indenting of code and of output that you want to show:
http://support.sas.com/forums/thread.jspa?messageID=27609毙
cynthia
