topic Keep records with 60 or more days of gap in SAS Programming

Keep records with 60 or more days of gap

lillymaginta — Wed, 20 Mar 2019 13:12:31 GMT

data test;
input id$2. start  end ;
attrib start format =date9. informat=date9.;
attrib end format =date9. informat=date9.;
datalines;
1 01JAN2015 14FEB2015
1 18FEB2015 30APR2015

2 01jan2015 28JAN2015
2 01apr2015 30apr2015

3 01JAN2015 14FEB2015
3 15FEB2015 15MAR2015
3 20MAR2015 30APR2015
;
run;

I have the above data, there are multiple records per id I want to apply the following criteria:

-keep all records with more than 60 days gap between end of one period and the start of the other

-keep only the first record if if the end dat of one period and the start of ther others are less than 60 days

2 01apr2015 30apr2015

Output

1 01JAN2015 14FEB2015

2 01jan2015 28JAN2015

2 01apr2015 30apr2015

3 01JAN2015 14FEB2015

Re: Keep records with 60 or more days of gap

novinosrin — Wed, 20 Mar 2019 13:12:58 GMT

data test;
input id$2. start  end ;
attrib start format =date9. informat=date9.;
attrib end format =date9. informat=date9.;
datalines;
1 01JAN2015 14FEB2015
1 18FEB2015 30APR2015
2 01jan2015 28JAN2015
2 01apr2015 30apr2015
3 01JAN2015 14FEB2015
3 15FEB2015 15MAR2015
3 20MAR2015 30APR2015
;
run;

data want;
set test;
by id;
l=lag(end);
if first.id then f=1;
else do;
if  start-l>60 then f=1;
else f=0;
end;
if f;
drop l f;
run;

Re: Keep records with 60 or more days of gap

lillymaginta — Wed, 20 Mar 2019 13:15:45 GMT

Thank you!

Re: Keep records with 60 or more days of gap

novinosrin — Wed, 20 Mar 2019 13:17:00 GMT

Hi @lillymaginta You are welcome. Plus, Thank you for posting the sample HAVE and WANT clearly. That makes it so much convenient.