Current month vs Rolling month

[Siddhartha]

Hi,

I am having the following variables as pr_num,week,product,total_rxn,total_rx,sbu,terri_state and district.
I want to group the product by terri_state ,total_rxn,total_rx,district for the current month & previous month(here the date format is like this ddmmyyyy.
I need to develop a report for the current month & previous month.
Can anyone help me in this regard.

Regards,
Sid

[Patrick]

May be you should invest a bit more energy in formulating a structured question before you post the same thing into 3 different forums (2 here plus SAS-L)...

[Cynthia_sas]

Hi:
I agree with Patrick. A -lot- more information is needed. I've posted some ideas in my answer to your post of this same question in the ODS forum.

cynthia

[sbb]

Demonstrate with INPUT data and OUTPUT information, as you would like to see generated by a SAS program.

Scott Barry
SBBWorks, Inc.