topic Re: Greater than last Friday using WHERE in SAS Programming

Greater than last Friday using WHERE

ywon111 — Mon, 04 May 2020 00:06:07 GMT

Is there a way to include dates greater than last Friday into this where statement.

where expiry = '31DEC9999:23:59:59'dt;

Thanks

Re: Greater than last Friday using WHERE

PaigeMiller — Mon, 04 May 2020 00:13:57 GMT

Are you talking specifically about Friday, May 1, 2020? Or do you want code that automatically figures out what date last Friday was?

Is variable EXPIRY really a date-time variable as your code snippet implies?

Re: Greater than last Friday using WHERE

ywon111 — Mon, 04 May 2020 00:13:46 GMT

To automatically figure out date of last Friday.

Thanks

Re: Greater than last Friday using WHERE

PaigeMiller — Mon, 04 May 2020 00:15:20 GMT

Is EXPIRY a date variable or a date-time variable?

Re: Greater than last Friday using WHERE

ywon111 — Mon, 04 May 2020 00:16:39 GMT

It is a date-time variable

Re: Greater than last Friday using WHERE

PaigeMiller — Mon, 04 May 2020 00:21:43 GMT

So any time expiry is greater than 23:59:59 on the last Friday ... which is the same as any date-time greater than or equal to Saturday at 00:00:00, this should do it.

where expiry >= intnx('dtweek.7',datetime(),0,'b');

Re: Greater than last Friday using WHERE

ballardw — Mon, 04 May 2020 02:12:04 GMT

If that obnoxious value is to indicate one that is not actually recorded then likely you should be using SAS Missing values.

Otherwise also sorts of "except when the value is this not actually the right value but we put it in anyway".