Desktop productivity for business analysts and programmers

Evalulation function

Reply
New Contributor
Posts: 4

Evalulation function

Hey,

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.

Thanks.

Super User
Super User
Posts: 6,845

Re: Evalulation function

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;

Ask a Question
Discussion stats
  • 1 reply
  • 202 views
  • 0 likes
  • 2 in conversation