Dividing panel data

[asdf]

Assume i have a panel dataset containing Firmid, year, CEOwage and I would like to remove the entire history of firmid's where the a wage higher than some given threshold some given year.

Example i want to remove all firms where the CEOwage is higher than 100 in year 2000.

How can I do this?

Sorry for stupid questions, I actually try though fail - though I admit I'm new to eviews.

[EViews Gareth]

Possibly an easier way to do it, but this works:

Code: Select all

smpl @all series inc = 1 smpl 2000 2000 if ceowage>100 inc = 0 smpl @all inc = @minsby(inc, @crossid) smpl if inc = 1