The percentage of independent directors on the board

[Dillon Steijn]

Hi everyone,

For my research I need 1 more control variable.
I need a control variable which equals the percentage of independent directors on the board.
I already have data from Boardex.
I also already have a variable (inddir) which equals 1 if the board member is ''Independent''.
I have data from a lot of different companies, from 2011-2019.
So basically, what I need, is for each different board, for each different year, calculate the percentage of independent directors on that board in that year.
Does anyone know how to get this? I would really appreciate your help!
My dataset looks as follows:

[Nick Cox]

Please do read https://www.statalist.org/forums/help#stata and give data examples using dataex. This may help so long as values of the Indicator are only 0, 1 or missing.

egen wanted = mean(100 * Inddir), by(Boardname YEAR)

See also https://www.stata-journal.com/articl...article=dm0099

[Dillon Steijn]

Thank you Nick Cox , I will have a read on that.
The code worked perfect for me!