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
data want;
set have;
if date gt '01Oct2006'd then delete;
run;
data want;
set have;
if date gt '01Oct2006'd then delete;
run;
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;
Thank you!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.