10-25-2013 09:06 PM
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.
10-25-2013 09:26 PM
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 ;
format date date9.;
data want ;
set have ;
where date between today()-10 and today();