Question CEO Duality applying to whole firm in a year

[Sjoerd Veldhuizen]

Hello everyone,

For my thesis I have to investigate CEO Duality. CEO Duality is when the CEO of the firm is also the chairman of the board.
I have created a variable CEO_Duality, which is 1 when a director is CEO and also chairman. But the problem is that when this is the case for a director, it has to be applied for the whole firm for this year.

For example:
year: 2007 CUSIP 000004 FULLNAME: Jeff Midnight CEO_Duality: 1
year: 2007 CUSIP 000004 FULLNAME: Jordan Knight CEO_Duality: 0
year: 2007 CUSIP 000004 FULLNAME: Jim Baker CEO_Duality: 0

Because Jeff Midnight serve a rol as CEO as wel as chairman CEO_Duality is 1, but I want for the whole firm with CUSIP 000004 that it get's a 1 because there is CEO Duality for this firm in 2007. So i want to create another variable which is 1 when one of the directors in a year is CEO as well as Chairman.

Does someone know how to do this?

Kind Regards,
Sjoerd

[Joro Kolev]

If your CEO_duaility variable is 0 or 1 and never missing, try

bysort CUSIP year (CEO_Duality): gen anyduality = CEO_duality[_N]

[Sjoerd Veldhuizen]

Thanks Joro Kolev, works exactly as i wanted!