topic Using today in New SAS User

Using today

Kirito1 — Wed, 11 Jan 2023 05:23:18 GMT

I was working on a dataset in SAS and I want to filter out data based on date. So right I am using this as a code.

data want;
set have;
where ('09JAN2023'd <= DATE_OF_APPROVAL <= '10JAN2023'd);
run;

Now, I want to use today as a function to do the above task so that everyday when I run code it takes the below logic.

data want;

set have;

where ((today()-2) <= DATE_OF_APPROVAL <= (today()-1));

run;

(the logic is based on today's date like if today is 11JAN2023 it should bring date of 09JAN2023 and 10JAN2023).

I just want guidance in approaching this problem.

Is this possible somehow in SAS. Please, help!!

Thanks

Re: Using today

ballardw — Wed, 11 Jan 2023 05:57:40 GMT

@Kirito1 wrote:

I was working on a dataset in SAS and I want to filter out data based on date. So right I am using this as a code.
data want;
set have;
where ('09JAN2023'd <= DATE_OF_APPROVAL <= '10JAN2023'd);
run;
Now, I want to use today as a function to do the above task so that everyday when I run code it takes the below logic.

data want;

set have;

where ((today()-2) <= DATE_OF_APPROVAL <= (today()-1));

run;

(the logic is based on today's date like if today is 11JAN2023 it should bring date of 09JAN2023 and 10JAN2023).

I just want guidance in approaching this problem.

Is this possible somehow in SAS. Please, help!!

Thanks

When in doubt try it:

data have;
   input datevar :date9.;
   format datevar date9.;
datalines;
08Jan2023
09Jan2023
10Jan2023
11Jan2023
12Jan2023
13Jan2023
14Jan2023
;

data want;
   set have;
   where (today()-2) le datevar le (today()-1);
run;

Re: Using today

Kirito1 — Wed, 11 Jan 2023 06:10:37 GMT

It only is getting data on date of (today -2 )

Re: Using today

Kurt_Bremser — Wed, 11 Jan 2023 06:33:04 GMT

Then you don't have dates for today()-1 in the dataset.

From where do your dates originate? If you imported from Excel, your dates may have invisible time components (Excel stores times as fraction of a day, not as count of seconds, and has therefore only datetime values).

Re: Using today

ballardw — Wed, 11 Jan 2023 07:45:20 GMT

@Kirito1 wrote:
It only is getting data on date of (today -2 )

With the code shown above creating the data set and running on 11JAN2023 the result I get is

Obs	datevar
1	09JAN2023
2	10JAN2023

If you are not getting such then perhaps you do not have a value in your set that your expect.

Re: Using today

Kirito1 — Wed, 11 Jan 2023 09:18:06 GMT

Nah using it directly is working something like below.
data want;
set have;
where today()-3 <= DATE_OF_APPROVAL <= today();
run;
Thanks for the contribution. 🙂