topic Re: calculating running average for Last 1 day, last 7 days and last 15 days ,, in SAS Programming

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

rajashekarmt — Tue, 24 Apr 2018 17:02:27 GMT

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

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

novinosrin — Tue, 24 Apr 2018 17:43:04 GMT

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

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

rajashekarmt — Wed, 25 Apr 2018 03:53:17 GMT

Dear sir, I explained the logic in the attached excel sheet

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

Patrick — Wed, 25 Apr 2018 06:11:31 GMT

@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.