I'm doing an assignment on executive payments and need to organise my data
set. currently i have a column for executive ID's (execid), companies for
which they work (GVKEY) and in what year (YEAR). I need to somehow organise
it so that only executive that have worked for at least 3 years for the same
company are showen in a new table and that this table includes all the years
they have worked for that company (including the first 2).
there is also other columns
If anybody could help it would be much appreciated. the data list is about
30,000 rows long so can't really do it manually.

Cheers