Greater than last Friday using WHERE

[ywon111]

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

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

Thanks

[PaigeMiller]

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?

[ywon111]

To automatically figure out date of last Friday.

Thanks

[PaigeMiller]

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

[ywon111]

It is a date-time variable

[PaigeMiller · Accepted solution]

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');

[ballardw]

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".