topic Re: delete observation occurred after a specific date in SAS Programming

delete observation occurred after a specific date

lillymaginta — Thu, 26 Oct 2017 09:25:44 GMT

id date

1 01/01/2005

2 01/02/2006

3 01/01/2007

I want to delete any observation after 10/01/2006

output

id date

1 01/01/2005

2 01/02/2006

ShiroAmada — Thu, 26 Oct 2017 09:28:40 GMT

data want;
  set have;
if date gt '01Oct2006'd then delete;
run;

ClarkLawson — Thu, 26 Oct 2017 09:32:40 GMT

Hello,

There are a few different options:

Using Delete

data output;
set input;

if date>'10Jan2006'd then delete;

run;

Using IF

data output;
set input;

if date<='10Jan2006'd then output; ** (Then output) is optional;

run;

Using Where

data output;
set input;
where date<='10Jan2006'd;
run;

Using Where Not

data output;
set input;
where not (date<='10Jan2006'd);
run;

Using SQL Delete

proc sql;
delete from dataset
where date>'10Jan2006'd
;
quit;

lillymaginta — Thu, 26 Oct 2017 12:03:08 GMT

Thank you!