01-31-2017 12:23 PM
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,
01-31-2017 12:44 PM
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.
02-01-2017 05:51 AM
I tried the your solution @KurtBremser, 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,
02-01-2017 06:00 AM
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.