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
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.