🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-26-2017 05:25 AM
(12419 views)
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data want;
set have;if date gt '01Oct2006'd then delete;
run;
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data want;
set have;if date gt '01Oct2006'd then delete;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!