Page 1 of 1

Dividing panel data

Posted: Tue Feb 11, 2014 12:37 pm
by 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.

Re: Dividing panel data

Posted: Tue Feb 11, 2014 1:09 pm
by 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