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
If you could please explain the calculation in terms of your numbers in the sample rather than algebraically, I would like to attempt .
@rajashekarmt wrote:
Dear sir, I explained the logic in the attached excel sheet
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.