delete observation occurred after a specific date

[lillymaginta]

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 · Accepted solution]

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

[ClarkLawson]

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]

Thank you!