topic Date in the where clause doesn't return any rows in SAS Programming

Date in the where clause doesn't return any rows

GN0001 — Tue, 28 Feb 2023 04:50:57 GMT

Hello team,

I have a date column whose date type is numeric, it is as: 7/20/2020

I want to place this date in a where clause.

Where date = '20Jul2020'd;

This doesn't bring any rows.

What is the reason?

Thanks,

blue blue

Re: Date in the where clause doesn't return any rows

Kurt_Bremser — Tue, 28 Feb 2023 05:53:06 GMT

Please post the complete log of the step.

Re: Date in the where clause doesn't return any rows

PaigeMiller — Tue, 28 Feb 2023 12:59:46 GMT

In addition to @Kurt_Bremser's request, please provide examples of typical values of the variable DATE that you are working with, and the FORMAT of the variable DATE.

Re: Date in the where clause doesn't return any rows

Kurt_Bremser — Tue, 28 Feb 2023 16:02:18 GMT

If this data was imported from Excel, you might have "hidden" time information in it, because Excel stores times as fractions of a day, not counts as seconds.

As illustration run this short code and look at the log:

data _null_;
format date mmddyy10.;
date = '20Jul2020'd;
put "date as is " date;
if date = '20Jul2020'd then put "yes";
date = date + .1;
put "date after addition " date;
if date = '20Jul2020'd then put "yes"; else put "no";
run;