DATA Step, Macro, Functions and more

delete observation occurred after a specific date

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 128
Accepted Solution

delete observation occurred after a specific date

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


Accepted Solutions
Solution
a month ago
Frequent Contributor
Posts: 100

Re: delete observation occurred after a specific date

Posted in reply to lillymaginta
data want;
  set have;
if date gt '01Oct2006'd then delete; run;

View solution in original post


All Replies
Solution
a month ago
Frequent Contributor
Posts: 100

Re: delete observation occurred after a specific date

Posted in reply to lillymaginta
data want;
  set have;
if date gt '01Oct2006'd then delete; run;
Occasional Contributor
Posts: 8

Re: delete observation occurred after a specific date

Posted in reply to lillymaginta

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;
Frequent Contributor
Posts: 128

Re: delete observation occurred after a specific date

Thank you! 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 104 views
  • 2 likes
  • 3 in conversation