To_date between to Dates

[mfaqueiroz]

Hello,

I want to filter my table (Tab1) by the time gap between 2016-01-01 and 2016-01-31, so I wrote the follow code:

Tab1.FirstDate BETWEEN  To_Date(20160101,'YYYYMMDD') AND To_Date(20160131,'YYYYMMDD')

But SAS does not recognize the To_Date function. Do you have any alternative suggestion?

Thanks in advance for your help,

🙂

[Kurt_Bremser]

Date literals in SAS are specified as "ddmmmyyyy"d.

In your case, you'd use "01jan2016"d and "31jan2016"d, respectively. No functions needed. You can also use single quotes.

[LinusH]

@Kurt_Bremser described how to do it in SAS.

To_date is a proprietary function to Oracle. SAS adhere to ANSI SQL, with SAS language add-ons.

[mfaqueiroz]

Hello,

I tried the your solution @Kurt_Bremser, but the following error message appears:

ERROR: Expression using equals (=) has components that are of different data types.

I have to change the date format?

Thank you for your willigness to help,

🙂

[Kurt_Bremser]

Please post the complete log of the step.

If you used the date literals exactly as I suggested, then your supposed date variable is not a date variable, but of type character.