Creating new variables CEO-duality and board independence from Orbis Global

[Tijn Jorissen]

Hi,

I'm currently working with data from Orbis Global and I'm stuck with making CEO-duality and board independence variable. I want to see these variables per year from 2012 untill 2021. The problem that I'm struggling with is the fact that there are mutliple lines per board member, so I'm trying to write a command that involves multiple rows.

I already tried something like this for the year 2012:

gen dual = 1 if appointmentyear <= 2012 & resignationyear > 2012 & naambestuurder == naambestuurder[_n-1] & boardcommitteeordepartment == "Senior management" & levelofresponsibility[_n-1] == "President / Chairman"
and
gen dual = 1 if appointmentyear <= 2012 & resignationyear > 2012 & naambestuurder == naambestuurder[_n-1] & boardcommitteeordepartment[_n-1] == "Senior management" & levelofresponsibility == "President / Chairman"
end

This is the data I'm working with:

* Example generated by -dataex-. For more info, type help dataex
clear
input str71 naambedrijf str12 bvdidnumber str121 naambestuurder int(appointmentyear resignationyear) str116 jobtitle str114 boardcommitteeordepartment str140 levelofresponsibility
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Alain Jean Leopold Vincent Boone"         1999 2030 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Alain Jean Leopold Vincent Boone"         1999 2030 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Alois Van Den Bergh"                      2010 2030 "Vice Chairman of the Board of Directors / Council of Management" "Board of Directors" "Vice President / Vice Chairman"
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Andre Armand Cesarine Raemdonck"          1999 2030 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Andre Armand Cesarine Raemdonck"          1999 2030 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Andre Flamand"                            1995 2030 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Andre Flamand"                            1995 2030 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Arnold Louis Meirlaen"                    2007 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Arnold Louis Meirlaen"                    2007 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bartholomeus Van Lysebeth"                2010 2030 "Vice Chairman of the Board of Directors / Council of Management" "Board of Directors" "Vice President / Vice Chairman"
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Basiel Eeckhout"                          2005 2007 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bernard De Cuyper"                        2007 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bernard De Cuyper"                        2001 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bert Misplon"                             2020 2030 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bert Misplon"                             2020 2026 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bert Misplon"                             2020 2026 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Blijde Vercamer"                          2007 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Blijde Vercamer"                          2007 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Boudewijn Erna Leopold Laloo"             2013 2023 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Boudewijn Erna Leopold Laloo"             2005 2023 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bruno Jacques Walter Matthys"             2009 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Bruno Jacques Walter Matthys"             2009 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Carl Jean Lionel Rachel Gerard De Decker" 2009 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Carl Jean Lionel Rachel Gerard De Decker" 2009 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Eddy D'Haese"                  2007 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2017 2024 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2007 2013 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2007 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2017 2024 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2019 2025 "Chairman of the Board of Directors / Council of Management"      "Board of Directors" "President / Chairman"          
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Christophe Willy Mario Peeters"           2017 2025 "Chairman of the Board of Directors"                              "Board of Directors" "President / Chairman"          
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Daniel Jozef Clement De Vlamynck"         2003 2007 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Daniel Termont"                           2013 2019 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Daniel Termont"                           2013 2019 "Vice Chairman of the Board of Directors / Council of Management" "Board of Directors" "Vice President / Vice Chairman"
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Daniel Termont"                           2007 2013 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Denis  Marie Aldegundis Omer A Dierick"   2013 2019 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Denis  Marie Aldegundis Omer A Dierick"   2013 2019 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Dirk Batsleer"                            2006 2007 "Director"                                                        "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Dirk Leo Elisabeth Holemans"              2013 2019 "Member of the Board of Directors"                                "Board of Directors" "Member"                        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Dirk Leo Elisabeth Holemans"              2013 2019 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Dirk Lodewijk"                            2013 2019 "Administrator"                                                   "Senior management"  "Unspecified executive"        
"TUSSENGEMEENTELIJKE MAATS. DER VL VR WATERVOORZIENING" "BE0200068636" "Mr Dirk Lodewijk"
end

[Emil Alnor]

Hi Tijn

Welcome to the forum. This is a multidisciplinary forum, meaning that you cannot expect members to be familiar with the concepts of "CEO-duality" and "board independence" or how these should be implemented in your data. I suggest you rewrite you problem explaining what you wish to achieve in non-domain-specific terms.