DATA Step, Macro, Functions and more

calculating running average for Last 1 day, last 7 days and last 15 days ,,

Reply
New Contributor
Posts: 2

calculating running average for Last 1 day, last 7 days and last 15 days ,,

 

Dear experts,

 

I need your help to calculate running avearages of transaction amount (tran_amt)backward from current day (t) to last 1day , last7days and last15 days  by account number (acc_id). please use the below data and sample calculations are shown in the columns Avg_L1D ( average(t + t-1), Avg_L7d (average( t, t-1,t-2,t-3,t-4,t-5,t-6,t-7) ) if any of lag transactions missing it shoud discard say if t-6 is missing then average will be average(t,t-1,t-2,t-3,t-4,t-5,t-7) etc. similarly for Avg_L15D...

 

CSV file attached for rawdata and the sample calcuation

 

thanks for your help

 

kind regards,

Raj

 

 

 

 

 

PROC Star
Posts: 1,592

Re: calculating running average for Last 1 day, last 7 days and last 15 days ,,

Posted in reply to rajashekarmt

If you could please explain the calculation in terms of your numbers in the sample rather than algebraically, I would like to attempt . 

New Contributor
Posts: 2

Re: calculating running average for Last 1 day, last 7 days and last 15 days ,,

Posted in reply to rajashekarmt
Dear sir, I explained the logic in the attached excel sheet
Respected Advisor
Posts: 4,687

Re: calculating running average for Last 1 day, last 7 days and last 15 days ,,

Posted in reply to rajashekarmt

@rajashekarmt wrote:
Dear sir, I explained the logic in the attached excel sheet

@rajashekarmt

Great that you've posted some data but you will also need to add some explanation in words how the logic works and not expect us to work this all out based on the numbers you've provided.

Ask a Question
Discussion stats
  • 3 replies
  • 96 views
  • 0 likes
  • 3 in conversation