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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.