USING IN () FOR DATES

[d6k5d3]

I have a Year column and a Date column. For a particular year, I want to delete a few dates. I was trying the following code, but not getting what I expect:

data aaa;
set bbb;
if year= 2007 and date in ('03/13/2007'd, '03/14/2007'd) then delete;
run;

I was getting the following error:

ERROR: Invalid date/time/datetime constant '03/13/2007'd.
ERROR: Invalid date/time/datetime constant '03/14/2007'd.
ERROR 77-185: Invalid number conversion on '03/14/2007'd.

Where did I go wrong? What should I do?

Much thanks!

[Astounding · Accepted solution]

Work with DATE only (not YEAR) but in a different form:

if date in ('13MAR2007'd, '14MAR2007'd) then delete;

[d6k5d3]

Awesome! Thank you!

[Tom]

The value inside the quotes of a datetime literal (constant) must be in a format that the DATE informat understands.

'01JAN2017'd
'01-JAN-2017'd
"1Jan17"d