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!