Your biggest issues is that you're specifying the dates incorrectly.
In SAS you need to specify a date as a 'date literal' which is using the DATE9 format, wrapping it in quotes and adding a d after wards.
'01Jan2018'd
This allows SAS to differentiate between a date and a character value.
As @LaurieF mentioned already, your logic was incorrect as well.
@mpoletika1 wrote:
Hello,
Brand new to SAS. I need to keep records only between July 1, 2015 and June 30, 2016 for the variable "entry_date." The dates look like 2015-07-01 and 2016-06-30 and the format says YYMMDD10. and the length is 8. Any code suggestions would helpful!
This is what I have right now.
data new; set input; if entry_date >= '2015-07-01'd and entry_date <= "2016-06-30" then delete; run;
Thanks,
Mike
... View more