Hi I was wondering if anyone could help me to create the variable(shown below) for my project
I have the dataset as shown in my attachment , it is not orginal data but the variables are similar
Variables
CEO_Ind = 1 if the Director_name is CEO , 0 otherwise
Ind_indicator = 1 if Director_name is independent , 0 otherwise
These two indicator variables are mutually exclusive for e.g. if CEO_Ind = 1 then by definition Ind_indicator = 0. However there could be non independent and non CEO i.e both the indicators will have 0
Variable I need is
For Firm_code 11 if the Director_name A also appears in any other company for instance Firm_code 265 along with any of other Directors that also appear in Firm_code 11 "within the same year" then Interlocking = 1 else Interlocking = 0
For instance as per the attached spreadsheet
For year = 2006
For FIRM_CODE 11 , Director A is accompanied by Directors B and C in 2006 and Directors A and C also appear for FIRM_CODE 265 so the interlocking variable for FIRM_CODE 11 will be 1 , 0 otherwise
Similarly for year = 2007
For FIRM_CODE 11 , Director A is accompanied by Directors B and C in 2007 and Directors A and B also appear for FIRM_CODE 265 so the interlocking variable for FIRM_CODE 11 will be 1 , 0 otherwise
... View more