Does anyone know how I can take the current day as well as the previous 10 days? I have been trying with evaluate functions but I cannot seem to figure it out.
I want to take the date today which I have in a dataset and then previous 10 days as well.
Not sure what you are asking. You can use the TODAY() function to get todays date.
10 days ago is just TODAY() - 10.
data have ;
date=today();
output;
date=today()-11;
output;
format date date9.;
run;
data want ;
set have ;
where date between today()-10 and today();
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!