topic Re: calculation of first 1 day last 7 days and 15 days average in SAS Programming

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

anilgvdbm — Wed, 25 Apr 2018 06:11:00 GMT

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

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

RW9 — Wed, 25 Apr 2018 08:29:46 GMT

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.

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

Kurt_Bremser — Wed, 25 Apr 2018 12:30:33 GMT

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.