Help using Base SAS procedures

SQL To Delete Observations by Key and Date Range

Reply
N/A
Posts: 0

SQL To Delete Observations by Key and Date Range

I have two different SAS datasets setup like the following...

Dataset1
ID Date
1 31/01/2009
1 28/02/2009
1 30/03/2009
...

Dataset2
1 StartDate EndDate
1 28/02/2009 29/03/2009

I wish to delete from dataset1 where StartDate (LE) date (LE) EndDate to leave the following

Dataset1
1 31/01/2009
1 30/03/2009
...

I've managed to come up with something that worked....
proc sql;
create table dataset1 as
select a.*
from dataset1 as a
left join
dataset2 as b
on a.id=b.id and (b.startdate LE a.date LE b.enddate)
having missing(b.id)
order by a.id, a.date
;
quit;

However, I was wondering if there was something that I could do in a "DELETE FROM" way?

I noticed that SQL could use the "DELETE FROM... USING" but couldn't get it to work.

Thanks in advance.

Message was edited by: Superman Message was edited by: Superman
N/A
Posts: 0

Re: SQL To Delete Observations by Key and Date Range

Sorry, double post. Message was edited by: Superman
Ask a Question
Discussion stats
  • 1 reply
  • 131 views
  • 0 likes
  • 1 in conversation