topic Nonoverlapping 3 months window in SAS Programming

Nonoverlapping 3 months window

yotsuba88 — Tue, 30 Jul 2019 18:17:50 GMT

Hi admin and others,

I have the data:

ID EventDate Value

1 17/07/1999 a

1 08/8/1999 b

1 20/11/1999 c

1 04/06/2003 d

1 11/05/2005 e

1 08/09/2005 ..

1 02/11/2005 --

1 17/2/2006 --

1 28/09/2006--

I want to delete for the same id during the three months before or after Eventdate. So if the 17/07/1999 then next date is 20/11/1999, delete 08/10/1999 because intck ("month", 17/07/1999, 08/08/1999)< 3 months. But if 08/08/1999 deleted, then I will check 17/07/1999 and 20/11/199, the distance is more than 3 months then I keep it.

The I tried to combine all data by itself by id, then if intck >3 then delete then I have two (17/7/1999 and 20/11/1999) ( 08/08/1999 and 20/11/1999) and I have no idea to delete 08/08. If first.date ... cannot work for this case and I cannot keep the last date if use intck.

Please help and advise.

Thank you so much,

Re: Nonoverlapping 3 months window

PaigeMiller — Tue, 30 Jul 2019 18:25:57 GMT

Are the comparisons always to the first date (17/07/1999) or to the previous non-deleted date?

Re: Nonoverlapping 3 months window

novinosrin — Tue, 30 Jul 2019 18:26:13 GMT

Hello @yotsuba88 Please post a sample of your expected OUTPUT(WANT) for the input sample(HAVE) with your explanation. Thank you!

Re: Nonoverlapping 3 months window

novinosrin — Tue, 30 Jul 2019 18:48:30 GMT

 

data have;
Input ID   EventDate   :ddmmyy10.          Value    $;
format EventDate   ddmmyy10. ;
cards;
1     17/07/1999       a 
1     08/8/1999       b
1    20/11/1999       c
1    04/06/2003        d
1    11/05/2005        e
;


data want;
set have;
by id;
retain _d;
if first.id then do;output; _d=eventdate;end;
else if intck('mon',_d,eventdate)>3 then do;output;_d=eventdate;end;
drop _d;
run;

Re: Nonoverlapping 3 months window

yotsuba88 — Wed, 31 Jul 2019 13:49:00 GMT

Hi Paige,

Thank you for your question. I want to compare with the previous non-deleted date.