DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 68

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

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

Super User
Super User
Posts: 9,402

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

Posted in reply to anilgvdbm

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.

 

Super User
Posts: 9,883

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

Posted in reply to anilgvdbm

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 89 views
  • 0 likes
  • 3 in conversation