topic Re: today() function between two dates in SAS Programming

today() function between two dates

zdassu — Wed, 17 Jul 2019 14:12:40 GMT

Hi I am trying to bring back data between two dates using the today() function. I don't think I can do this in Data step but is there an equivalent that I can use. See code that I have created below

data work.tempA;
keep Name_Id Address_Id;
set work.tempb;
WHERE is_current_flg = 1 AND record_deleted_flg = 0
AND today()between Valid_From_Dt and Valid_To_Dt;
run;

Re: today() function between two dates

PeterClemmensen — Wed, 17 Jul 2019 14:24:07 GMT

data work.tempA;
keep Name_Id Address_Id;
set work.tempb;
WHERE is_current_flg = 1 AND record_deleted_flg = 0
AND Valid_From_Dt le today() le Valid_To_Dt;
run;

Re: today() function between two dates

Tom — Wed, 17 Jul 2019 14:26:13 GMT

Did it not work? If so how? Did you get an error? Not get the expected results? Show example data that you though met the WHERE condition and didn't get selected (or the reverse).

Re: today() function between two dates

zdassu — Wed, 17 Jul 2019 14:31:29 GMT

Hi I tried that code but it does not bring back any records at all, the results table is blank

Re: today() function between two dates

Kurt_Bremser — Wed, 17 Jul 2019 14:31:34 GMT

Maxim 3: Know Your Data.

Are valid_from_dt and valid_to_dt SAS date values (numeric, with a date format attached)? If yes, run a proc freq on those columns to see which values they contain.

Re: today() function between two dates

Tom — Wed, 17 Jul 2019 14:35:11 GMT

Can you find an example that you think it should have found?

Please show the example data that fails to get selected but that you think it should select.

Make sure that the variables in your dataset are DATES (not strings, not datetime values, not numbers that humans might mistake for dates).

Re: today() function between two dates

Reeza — Wed, 17 Jul 2019 15:20:39 GMT

TODAY() returns today's date, of July 17. Are you sure that's what you want to be doing?