calculation of first 1 day last 7 days and 15 days average

[anilgvdbm]

Hi Team,

Need your help in calculating the average of 1 day, last 7 days and Last 15 days. I have the transaction amount by date and Account number.

I'm attaching the data for your reference.

thanks for the help.

Regards,

Kumar

[RW9]

Post test data in the form of a datastep, and what you want the output to look like.  

proc sql;
  create table want as 
  select "1 day" as cat,
         a.*,
         b.res
  from   have a 
  left join (select account,sum(amount) as res from have where a.date -1 <= date <= a.date) b
  on     a.account=b.account;
quit;

Shows one way which may work to get the 1 day, same thing for 7 and 15.

[Kurt_Bremser]

If you post example data in a csv, you should also post the code you use to read that data into a SAS dataset. Only then can we recreate your dataset exactly as it is.