topic Re: Remove after second-post period obs in SAS Programming

Remove after second-post period obs

hkim3677 — Sat, 14 Apr 2018 17:52:19 GMT

Hi,

I want to isolate the first pre-and post observations.

For example,

data example;

input id year event;

datalines;

a 1990 0

a 1991 0

a 1992 0

a 1993 1

a 1994 0

a 1995 0

a 1996 1

a 1997 0

b 1993 0

b 1994 0

b 1995 1

b 1996 0

b 1997 1

b 1998 0

b 1999 0

;

run;

I want to get this dataset. like..

data hope;

input id year event;

datalines;

a 1990 0

a 1991 0

a 1992 0

a 1993 1

a 1994 0

a 1995 0

b 1993 0

b 1994 0

b 1995 1

b 1996 0

;

run;

please help!

Re: Remove after second-post period obs

PeterClemmensen — Sat, 14 Apr 2018 17:56:49 GMT

I don't follow the logic here. Please be more specific.

Re: Remove after second-post period obs

hkim3677 — Sat, 14 Apr 2018 18:00:38 GMT

Each id has two events. So, I want to remove observations as of the second event year by id.

Re: Remove after second-post period obs

novinosrin — Sat, 14 Apr 2018 18:03:09 GMT

data example;

input id $ year event;

datalines;
a 1990 0
a 1991 0
a 1992 0
a 1993 1
a 1994 0 
a 1995 0
a 1996 1
a 1997 0
b 1993 0
b 1994 0
b 1995 1
b 1996 0
b 1997 1
b 1998 0
b 1999 0
;

run;

data want;
call missing(_e,__e);
do until(last.id);
set example;
by id year;
if  event and not _e then _e=1;
else if event and _e then __e=1;
if not __e then output;
end;
drop _:;
run;

Re: Remove after second-post period obs

PeterClemmensen — Sat, 14 Apr 2018 18:04:42 GMT

Something like this?

data want(drop=flag);
   set example;
   by id;
   if first.id then flag=0;
   if event=1 then flag+1;
   retain flag;
   if flag<2;
run;

Re: Remove after second-post period obs

hkim3677 — Sat, 14 Apr 2018 18:07:52 GMT

Thank you!

Re: Remove after second-post period obs

PeterClemmensen — Sat, 14 Apr 2018 18:08:24 GMT

No problem 🙂