topic Re: To_date between to Dates in SAS Enterprise Guide

To_date between to Dates

mfaqueiroz — Tue, 31 Jan 2017 17:23:40 GMT

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 — Tue, 31 Jan 2017 17:44:01 GMT

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 — Tue, 31 Jan 2017 21:17:25 GMT

@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 — Wed, 01 Feb 2017 10:51:24 GMT

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 — Wed, 01 Feb 2017 11:00:30 GMT

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.