topic USING IN () FOR DATES in New SAS User

USING IN () FOR DATES

d6k5d3 — Mon, 07 Jan 2019 20:46:45 GMT

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!

Re: USING IN () FOR DATES

Astounding — Mon, 07 Jan 2019 20:50:26 GMT

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

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

Re: USING IN () FOR DATES

d6k5d3 — Mon, 07 Jan 2019 20:58:21 GMT

Awesome! Thank you!

Re: USING IN () FOR DATES

Tom — Mon, 07 Jan 2019 21:13:41 GMT

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