topic Delete first two years in a panel in SAS Programming

Delete first two years in a panel

dapenDaniel — Thu, 09 Apr 2020 04:02:14 GMT

Hi,

I have a panel dataset like below.

data have;
input firmID $	Year	;
datalines;
A	1995	
A	1996	
A	1997	
A	1998	
B	1997	
B	1998	
B	1999	
B   2000
;
run;

I would like to delete the first two years for each firm. The expected output is below.

data have;
input firmID $	Year;
datalines;
A	1997	
A	1998	
B	1999	
B   2000
;
run;

What program do I need to use? Thanks!!

Kurt_Bremser — Thu, 09 Apr 2020 04:08:59 GMT

Use a counter with by-group processing, and a subsetting if:

data want;
set have;
by firmid;
if first.firmid
then counter = 1;
else counter + 1;
if counter > 2;
drop counter;
run;

dapenDaniel — Thu, 09 Apr 2020 05:07:24 GMT

Thanks!