topic Re: Evalulation function in SAS Enterprise Guide

Evalulation function

SMorrison07 — Sat, 26 Oct 2013 01:06:04 GMT

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.

Re: Evalulation function

Tom — Sat, 26 Oct 2013 01:26:33 GMT

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;