CEOs transitions

[Marc Pascual]

Good morning,

I'm trying to create a variable to see if the transition of a company's CEO is Male to Female or another type of transition.
I have data on the Gender of the CEOs, their ID, the company's ID and the year, but I don't know how to classify per company and year who is their CEO to be able to determine what the transition (if any) is.

Thanks!

[Emil Alnor]

Provide a dataexample using -dataex to improve your chances of recieving an answer.

[Marc Pascual]

Good morning, thanks for your response! Here is my data example:

* Example generated by -dataex-. For more info, type help dataex
clear
input str6(GENDER EXECID GVKEY) double YEAR
"0" "00006" "001013" 1993
"0" "00006" "001013" 1998
"0" "06390" "001034" 1994
"0" "06390" "001034" 1996
"0" "06390" "001034" 1998
"0" "03661" "001045" 1998
"0" "03661" "001045" 1999
"0" "00759" "001075" 1996
"0" "10739" "001075" 2004
"0" "00003" "001078" 1997
"0" "00015" "001209" 1995
"0" "00015" "001209" 2000
"0" "03915" "001230" 1996
"0" "03915" "001230" 1997
"0" "14871" "001230" 2004
"0" "00017" "001240" 1996
"0" "00017" "001240" 1998
"0" "00017" "001240" 2000
"0" "02076" "001243" 2000
"0" "01461" "001246" 1995
"0" "12194" "001246" 2000
"0" "00021" "001254" 1993
"0" "00021" "001254" 1997
"0" "03932" "001254" 2004
"0" "03932" "001254" 2005
"0" "00024" "001279" 1993
"0" "00024" "001279" 1995
"0" "03940" "001279" 1998
"0" "03940" "001279" 2001
"0" "12422" "001318" 1999
"0" "00030" "001356" 1996
"0" "01510" "001356" 2002
"0" "08515" "001372" 1997
"0" "01148" "001408" 1995
"0" "01148" "001408" 1998
"0" "08688" "001410" 1994
"0" "11710" "001468" 1999
"0" "14543" "001478" 2004
"0" "14543" "001478" 2005
"0" "01768" "001567" 2000
"0" "01768" "001567" 2003
"0" "14573" "001581" 1999
"0" "00052" "001587" 1994
"0" "00054" "001598" 1996
"0" "00054" "001598" 1998
"0" "05953" "001608" 1994
"0" "20255" "001634" 2004
"0" "03981" "001655" 1996
"0" "11572" "001677" 1996
"0" "11572" "001677" 1997
"0" "09034" "001677" 2003
"0" "10360" "001686" 1996
"0" "14302" "001690" 2001
"0" "25876" "001704" 2003
"0" "13958" "001722" 2000
"0" "00075" "001786" 1994
"0" "00075" "001786" 1996
"0" "00081" "001837" 1993
"0" "00081" "001837" 1996
"0" "00083" "001848" 1993
"0" "06501" "001865" 1993
"0" "02387" "001913" 2004
"0" "00090" "001919" 1996
"0" "00090" "001919" 1998
"0" "00092" "001976" 1996
"0" "06500" "001981" 1995
"0" "06511" "001981" 1998
"0" "10850" "001988" 2005
"0" "01291" "001995" 1994
"0" "01291" "001995" 2001
"0" "10939" "002034" 1996
"0" "10939" "002034" 2000
"0" "02463" "002044" 1997
"0" "02463" "002044" 2003
"0" "12843" "002055" 1999
"0" "11122" "002085" 1997
"0" "11122" "002085" 1999
"0" "17856" "002101" 2001
"0" "17856" "002101" 2004
"0" "10110" "002111" 2001
"0" "01131" "002136" 2005
"0" "09488" "002138" 2002
"1" "23550" "002150" 1999
"0" "00121" "002154" 1998
"0" "27690" "002154" 2004
"0" "13346" "002169" 1998
"0" "13346" "002169" 1999
"0" "00127" "002189" 1997
"0" "03334" "002269" 1996
"0" "03334" "002269" 1997
"0" "04115" "002282" 2004
"0" "00141" "002285" 1995
"0" "00147" "002337" 1993
"0" "01022" "002337" 1996
"0" "01022" "002337" 2003
"0" "01022" "002337" 2004
"0" "12306" "002346" 2003
"0" "02678" "002393" 2003
"0" "01523" "002403" 1996
"0" "01523" "002403" 1997
"0" "00154" "002439" 1994
"0" "00154" "002439" 1995
"0" "16459" "002444" 2003
"0" "16459" "002444" 2004
"0" "00830" "002490" 1996
"0" "00830" "002490" 1999
"0" "22393" "002497" 2005
"0" "14356" "002504" 1999
"0" "15081" "002538" 1998
"0" "15081" "002538" 1999
"0" "02158" "002538" 2004
"0" "23867" "002555" 2003
"0" "16276" "002577" 2002
"0" "16276" "002577" 2003
"0" "16276" "002577" 2005
"0" "09180" "002625" 1996
"0" "12560" "002663" 2002
"0" "04786" "002771" 1995
"0" "04786" "002771" 1999
"0" "04786" "002771" 2000
"0" "18546" "002771" 2004
"0" "01594" "002783" 2000
"0" "01594" "002783" 2001
"0" "16729" "002783" 2005
"0" "05353" "002787" 1995
"0" "08109" "002807" 1995
"0" "08109" "002807" 1997
"0" "08110" "002807" 2001
"0" "08110" "002807" 2003
"0" "21654" "002811" 2000
"0" "02777" "002817" 1999
"0" "03852" "002845" 1993
"0" "03852" "002845" 2003
"0" "21643" "002856" 1998
"0" "21643" "002856" 1999
"0" "21643" "002856" 2000
"0" "21643" "002856" 2001
"0" "05626" "002859" 1997
"0" "00187" "002860" 1993
"0" "27642" "002916" 2005
"0" "12369" "002940" 1999
"0" "00809" "002982" 1998
"0" "00809" "002982" 2000
"0" "10992" "003026" 2003
"0" "28032" "003026" 2004
"0" "14822" "003036" 2000
"0" "14822" "003036" 2001
"0" "06248" "003041" 1993
"0" "06248" "003041" 1995
"0" "11416" "003054" 2005
"0" "04950" "003063" 1995
"1" "17057" "003087" 2003
"0" "10860" "003093" 1995
"0" "10861" "003093" 2000
"0" "10861" "003093" 2003
"0" "10861" "003093" 2005
"0" "12528" "003105" 1995
"0" "12528" "003105" 2002
"0" "05019" "003107" 1994
"0" "05022" "003107" 1999
"0" "05022" "003107" 2005
"0" "00221" "003121" 1995
"0" "00221" "003121" 1997
"1" "17690" "003126" 1999
"1" "17690" "003126" 2003
"1" "17690" "003126" 2005
"0" "14266" "003144" 2003
"0" "11286" "003157" 1999
"0" "18414" "003158" 1998
"0" "00238" "003282" 1994
"0" "00238" "003282" 1996
"0" "02088" "003336" 1999
"0" "03837" "003362" 1994
"0" "13734" "003362" 1999
"0" "13734" "003362" 2000
"0" "13734" "003362" 2004
"0" "24486" "003362" 2005
"0" "00248" "003416" 1993
"0" "00248" "003416" 1994
"0" "13125" "003439" 2005
"0" "01522" "003497" 1995
"0" "01522" "003497" 2004
"0" "00256" "003502" 1993
"0" "01404" "003502" 1995
"0" "02140" "003505" 2005
"0" "00260" "003532" 1993
"0" "01221" "003532" 1998
"0" "00268" "003607" 1998
"0" "00268" "003607" 2003
"0" "27860" "003607" 2005
"0" "00269" "003619" 1994
"0" "00269" "003619" 1998
"0" "02203" "003650" 1997
"0" "02205" "003650" 2001
"0" "00274" "003734" 1993
"0" "00274" "003734" 1996
"0" "10348" "003814" 2001
"0" "10348" "003814" 2002
"0" "00283" "003851" 1995
"0" "01383" "003851" 2002
"0" "00158" "003851" 2004
"0" "01634" "003863" 1995
"0" "01634" "003863" 1996
"0" "00287" "003897" 1993
"0" "00287" "003897" 1994
"0" "01298" "003897" 1999
"0" "01298" "003897" 2001
"0" "01298" "003897" 2005
"0" "13999" "003937" 2003
"0" "13999" "003937" 2004
"0" "18493" "003946" 2000
"0" "17423" "003971" 2004
"0" "05466" "004036" 1998
"0" "01504" "004058" 1996
"0" "01504" "004058" 1997
"0" "01504" "004058" 2000
"0" "01504" "004058" 2002
"0" "00301" "004060" 1993
"0" "00301" "004060" 1994
"0" "00715" "004066" 1996
"0" "00309" "004087" 1993
"0" "01171" "004093" 1994
"0" "18455" "004103" 2000
"0" "05483" "004108" 1994
"0" "05483" "004108" 1997
"0" "07953" "004132" 1993
"0" "07953" "004132" 1996
"0" "16771" "004145" 2002
"0" "00657" "004194" 1997
"0" "00317" "004199" 1995
"0" "01829" "004213" 2001
"0" "04261" "004218" 1997
"0" "15693" "004274" 1999
"0" "14042" "004351" 1997
"0" "14042" "004351" 1999
"0" "09240" "004351" 2003
"0" "04322" "004423" 1998
"0" "04322" "004423" 1999
"0" "09200" "004430" 1996
"0" "16404" "004460" 2005
"0" "00337" "004462" 1995
"0" "00384" "004510" 1993
"0" "00384" "004510" 1999
"0" "20951" "004510" 2003
"0" "00391" "004517" 1993
"0" "26058" "004517" 2004
"0" "12941" "004600" 1998
"0" "00347" "004611" 1994
"0" "00347" "004611" 1995
"0" "10173" "004611" 2002
"0" "01840" "004622" 2002
"0" "01840" "004622" 2003
"0" "11193" "004675" 2000
"0" "02636" "004769" 1997
"0" "00381" "004800" 1994
"0" "00381" "004800" 1995
"0" "08051" "004807" 1998
"0" "00383" "004818" 1994
"0" "18101" "004818" 2002
"0" "18101" "004818" 2005
"0" "02662" "004839" 1996
"0" "23438" "004839" 2003
"0" "23438" "004839" 2004
"0" "23438" "004839" 2005
"0" "22417" "004844" 2002
"0" "11771" "004847" 1998
"0" "16286" "004926" 2001
"0" "06367" "004941" 1998
"0" "02698" "004990" 1996
"0" "00404" "005020" 1993
"0" "01393" "005046" 1993
"0" "02723" "005046" 2002
"0" "01503" "005074" 2004
"0" "03748" "005109" 2000
"0" "03748" "005109" 2001
"0" "01259" "005125" 2005
"0" "23552" "005179" 2000
"0" "12402" "005229" 1999
"0" "01918" "005229" 2000
"0" "01918" "005229" 2001
"0" "12402" "005229" 2002
"0" "00432" "005234" 1993
"0" "01194" "005250" 1998
"0" "23671" "005252" 2001
"0" "23671" "005252" 2004
"0" "13435" "005301" 1998
"0" "13435" "005301" 2004
"0" "27017" "005301" 2005
"0" "01739" "005306" 1996
"0" "00450" "005492" 1995
"0" "02416" "005492" 2001
"0" "23068" "005492" 2004
"0" "04550" "005496" 2000
"0" "04550" "005496" 2005
"0" "02427" "005505" 1997
"0" "02429" "005505" 1998
"0" "02429" "005505" 2003
"0" "16575" "005597" 2005
"0" "01474" "005606" 1998
"1" "17976" "005606" 2004
"0" "00467" "005639" 1994
"0" "00467" "005639" 1999
"0" "20786" "005639" 2001
"0" "20786" "005639" 2003
"0" "09398" "005671" 1994
"0" "09398" "005671" 1995
"0" "09398" "005671" 1996
"0" "09398" "005671" 1997
"0" "01373" "005709" 1999
"0" "20344" "005723" 1999
"0" "10794" "005742" 2003
"0" "10794" "005742" 2004
"0" "10444" "005772" 2001
"0" "06488" "005803" 1994
"0" "02625" "005860" 1995
"0" "04608" "005870" 2003
"0" "04608" "005870" 2005
"0" "00489" "005877" 1993
"0" "00489" "005877" 1995
"0" "00489" "005877" 1996
"0" "00489" "005877" 1998
"0" "01072" "005905" 1994
"0" "04616" "005918" 1997
"0" "04620" "005918" 1998
"0" "04618" "005918" 1999
"0" "04620" "005918" 2000
"0" "04620" "005918" 2002
"0" "04620" "005918" 2003
"0" "01323" "005959" 1994
"0" "00496" "005968" 1994
"0" "00496" "005968" 1996
"0" "13922" "005973" 2005
"0" "09883" "005978" 1996
"0" "00498" "006008" 1996
"0" "01158" "006008" 1998
"0" "16248" "006025" 1998
"0" "06986" "006044" 2000
"0" "21439" "006078" 2000
"0" "21439" "006078" 2001
"0" "21439" "006078" 2004
"0" "00672" "006081" 1994
"0" "03034" "006081" 1995
"0" "01099" "006097" 1999
"0" "05916" "006097" 2002
"0" "05916" "006097" 2003
"0" "04660" "006102" 1993
"0" "00504" "006104" 1995
"0" "18210" "006116" 2005
"0" "09756" "006125" 1996
"0" "09760" "006125" 1999
"0" "09760" "006125" 2000
"0" "09760" "006125" 2002
"0" "09760" "006125" 2005
"0" "23760" "006152" 2001
"0" "23760" "006152" 2005
"0" "01472" "006268" 2004
"0" "01912" "006272" 1993
"0" "01912" "006272" 1994
"0" "00520" "006307" 1993
"0" "07005" "006310" 1998
"0" "01547" "006310" 2002
"0" "04644" "006334" 2003
"0" "10904" "006335" 2002
"0" "13396" "006338" 2001
"0" "06762" "006346" 1996
"0" "16560" "006357" 2003
"0" "16560" "006357" 2004
"0" "12459" "006375" 2000
"0" "12459" "006375" 2003
"0" "08048" "006376" 2002
"0" "05641" "006386" 1998
"0" "05641" "006386" 1999
"0" "00532" "006435" 1996
"0" "00532" "006435" 1999
"0" "00532" "006435" 2002
"0" "02771" "006502" 2004
"0" "18523" "006547" 2005
"0" "01464" "006565" 2000
"0" "04937" "006574" 1999
"0" "04937" "006574" 2002
"0" "19475" "006617" 2001
"0" "03388" "006768" 1996
"0" "03388" "006768" 1997
"0" "02790" "006774" 2003
"0" "12163" "006796" 1996
"0" "02621" "006821" 2002
"0" "02833" "006829" 2002
"0" "01496" "006830" 1996
"0" "01496" "006830" 1998
"0" "10382" "006845" 1996
"0" "27335" "006900" 2005
"0" "08509" "006994" 1996
"0" "13189" "006994" 2002
"0" "00992" "007017" 1993
"0" "00589" "007065" 1999
"0" "12687" "007065" 2004
"0" "16317" "007065" 2005
"0" "10630" "007086" 2002
"0" "07042" "007107" 2001
"0" "00595" "007116" 1995
"1" "01412" "007116" 1998
"0" "06020" "007146" 1998
"0" "06020" "007146" 2000
"0" "06020" "007146" 2003
"0" "03685" "007154" 1994
"0" "14881" "007154" 2005
"0" "00611" "007180" 1993
"0" "00616" "007228" 1995
"0" "12158" "007291" 1995
"0" "00332" "007366" 1994
"0" "27714" "007366" 2002
"0" "27714" "007366" 2004
"0" "00637" "007380" 1994
"0" "11912" "007401" 1997
"0" "00639" "007409" 1993
"0" "11039" "007409" 1998
"0" "00641" "007435" 1997
"0" "00641" "007435" 1998
"0" "00641" "007435" 1999
"0" "27743" "007437" 2005
"0" "12000" "007448" 1995
"0" "12000" "007448" 1996
"0" "12000" "007448" 1997
"0" "12000" "007448" 2002
"0" "11684" "007486" 2004
"0" "20596" "007504" 1999
"0" "20596" "007504" 2000
"0" "00651" "007537" 1994
"0" "01077" "007554" 1993
"0" "00654" "007567" 1993
"0" "05114" "007637" 1994
"0" "05114" "007637" 2000
"0" "24999" "007637" 2002
"0" "24999" "007637" 2004
"0" "24999" "007637" 2005
"0" "12353" "007648" 1996
"0" "12675" "007672" 1995
"0" "07006" "007691" 1997
"0" "16986" "007691" 2002
"0" "08744" "007723" 1998
"0" "04042" "007733" 2004
"0" "03828" "007750" 1993
"0" "03828" "007750" 1998
"0" "03828" "007750" 2000
"0" "04995" "007772" 2001
"0" "04995" "007772" 2002
"0" "03024" "007773" 1993
"0" "03024" "007773" 1995
"0" "15261" "007799" 1999
"0" "00674" "007824" 1994
"0" "07624" "007824" 2004
"0" "01544" "007835" 1999
"0" "01544" "007835" 2001
"0" "00675" "007837" 1996
"0" "00675" "007837" 1997
"0" "12847" "007866" 2002
"1" "16305" "007866" 2005
"0" "01587" "007881" 1995
"0" "01587" "007881" 1998
"0" "21748" "007883" 2001
"0" "21748" "007883" 2003
"0" "21745" "007883" 2004
"0" "03117" "007904" 1998
"0" "03117" "007904" 2000
"0" "04185" "007921" 2001
"0" "05700" "007970" 2005
"0" "00687" "007974" 1995
"0" "00687" "007974" 2002
"0" "00202" "007977" 2001
"0" "29584" "007977" 2003
"0" "04688" "007993" 1997
"0" "16911" "007993" 2003
"0" "09409" "008003" 1994
"0" "03258" "008030" 1998
"0" "05896" "008030" 2004
"0" "05896" "008030" 2005
"0" "06564" "008049" 1994
"0" "08228" "008092" 1996
"0" "01275" "008099" 1993
"0" "01275" "008099" 1994
"0" "01275" "008099" 1997
"0" "01526" "008099" 1999
"0" "01526" "008099" 2000
"0" "08074" "008133" 1995
"0" "08074" "008133" 1999
"0" "08074" "008133" 2002
"0" "03349" "008151" 2000
"0" "00721" "008214" 1994
"0" "00721" "008214" 1996
"0" "00770" "008247" 1993
"0" "01892" "008247" 1994
"0" "01673" "008247" 2000
"0" "01673" "008247" 2003
"0" "00724" "008272" 1994
"0" "05365" "008290" 1994
"0" "05365" "008290" 1997
"0" "00733" "008325" 1994
"0" "17506" "008333" 2003
"0" "17506" "008333" 2004
"0" "17506" "008333" 2005
"0" "27162" "008402" 2005
"0" "09633" "008404" 1994
"0" "03557" "008446" 1997
"0" "07783" "008452" 1994
"0" "00742" "008468" 1997
"0" "00744" "008470" 1995
"0" "00744" "008470" 2001
"0" "00746" "008479" 1993
"0" "01116" "008479" 1999
"0" "34577" "008512" 2005
"0" "00751" "008530" 1994
"0" "00751" "008530" 1995
"0" "00751" "008530" 1996
"0" "00752" "008536" 1995
"0" "01493" "008543" 1996
"0" "01493" "008543" 1998
"0" "01493" "008543" 2000
"0" "05960" "008549" 2003
"0" "00757" "008551" 1996
"0" "00757" "008551" 2004
"0" "00579" "008570" 1994
"0" "08947" "008579" 2005
"0" "08068" "008599" 2002
"0" "00762" "008617" 1996
"0" "03058" "008626" 1995
"0" "14436" "008626" 1998
"0" "14436" "008626" 2003
"0" "03070" "008692" 1998
"0" "03071" "008692" 2004
"0" "00769" "008694" 1994
"0" "04702" "008694" 1998
"0" "27916" "008694" 2003
"0" "01639" "008717" 2000
"0" "00779" "008762" 1994
"0" "04671" "008804" 1997
"0" "04671" "008804" 1998
"0" "04733" "008807" 1996
"0" "04739" "008807" 2000
"0" "04739" "008807" 2002
"0" "27527" "008815" 2004
"0" "24789" "008818" 2005
"0" "03097" "008823" 1997
"0" "03097" "008823" 1998
"0" "23492" "008873" 2004
"0" "01770" "008972" 2000
"0" "03114" "008972" 2005
"0" "03900" "009069" 1993
"0" "17978" "009112" 2001
"0" "03125" "009155" 1997
"0" "03125" "009155" 1998
"0" "00811" "009168" 1993
"0" "00813" "009195" 1995
"0" "03150" "009203" 1998
"0" "11768" "009216" 2002
"0" "00815" "009217" 1993
"0" "14201" "009224" 1999
"0" "00816" "009225" 1995
"0" "00816" "009225" 1999
"0" "00807" "009236" 1993
"0" "07205" "009248" 1996
"0" "12393" "009299" 2001
"0" "12393" "009299" 2002
"0" "29139" "009302" 2005
"0" "05207" "009332" 1995
"0" "21798" "009340" 2004
"0" "03214" "009372" 1994
"0" "03214" "009372" 1995
"0" "14815" "009445" 1996
"0" "01136" "009459" 2001
"0" "16308" "009465" 2004
"0" "09384" "009673" 1995
"0" "01414" "009699" 2001
"0" "23847" "009761" 2003
"0" "23847" "009761" 2005
"0" "19695" "009774" 2001
"0" "04330" "009777" 2002
"0" "20901" "009778" 2001
"0" "00866" "009815" 1997
"0" "00833" "009846" 1997
"0" "00833" "009846" 2004
"0" "00868" "009850" 1993
"0" "01141" "009850" 1998
"0" "07338" "009890" 1998
"0" "14888" "009904" 2002
"0" "08621" "009919" 2001
"0" "19776" "009999" 2003
"0" "11430" "010002" 2003
"0" "21898" "010005" 2002
"0" "21898" "010005" 2004
"0" "21898" "010005" 2005
"0" "18649" "010016" 2001
"0" "19422" "010085" 2002
"0" "05705" "010109" 1994
"0" "00898" "010156" 1999
"0" "12913" "010156" 2005
"0" "07366" "010174" 1993
"0" "07366" "010174" 1996
"0" "18986" "010195" 2005
"0" "01249" "010247" 1999
"0" "03363" "010247" 2000
"0" "03363" "010247" 2001
"0" "13949" "010247" 2005
"0" "16309" "010277" 1998
"0" "16309" "010277" 2001
"0" "10507" "010277" 2003
"0" "00954" "010301" 1998
"0" "26715" "010331" 2003
"0" "00855" "010332" 2003
"0" "19334" "010374" 2003
"0" "00922" "010405" 1996
"0" "03936" "010405" 1999
"0" "05573" "010407" 1995
"0" "27664" "010420" 2004
"0" "08483" "010422" 1994
"0" "03424" "010426" 2002
"0" "19490" "010443" 2000
"0" "19490" "010443" 2001
"0" "19490" "010443" 2004
"0" "19490" "010443" 2005
"0" "01130" "010482" 1994
"0" "03456" "010482" 1996
"0" "03456" "010482" 1997
"0" "05709" "010499" 2001
"0" "01156" "010507" 1996
"0" "01156" "010507" 2000
"0" "01156" "010507" 2001
"0" "00931" "010519" 1996
"0" "01561" "010519" 2000
"0" "01561" "010519" 2002
"0" "21489" "010530" 2005
"0" "00934" "010540" 2001
"0" "03543" "010540" 2003
"0" "03543" "010540" 2005
"0" "00002" "010553" 1993
"0" "13956" "010553" 2001
"0" "03706" "010565" 2000
"0" "03706" "010565" 2001
"0" "03553" "010581" 2000
"0" "16077" "010618" 2005
"0" "00944" "010631" 2000
"0" "00944" "010631" 2001
"0" "12464" "010631" 2003
"0" "03589" "010639" 1994
"0" "03589" "010639" 1995
"0" "19436" "010757" 2005
"0" "17982" "010793" 2001
"0" "17982" "010793" 2002
"0" "17982" "010793" 2004
"0" "17402" "010816" 1998
"0" "17402" "010816" 2004
"0" "24413" "010860" 2000
"0" "00971" "010867" 1994
"0" "01162" "010867" 1999
"0" "01162" "010867" 2001
"0" "22709" "010877" 2001
"0" "22709" "010877" 2004
"0" "28209" "010884" 2004
"0" "15171" "010981" 1999
"0" "12905" "010993" 1994
"0" "12905" "010993" 1996
"0" "12905" "010993" 1998
"0" "02957" "011040" 1996
"0" "00994" "011056" 1995
"0" "00994" "011056" 1999
"0" "01508" "011060" 1996
"0" "01508" "011060" 2002
"0" "01508" "011060" 2005
"0" "01202" "011096" 2004
"0" "01009" "011228" 1994
"0" "01011" "011259" 1996
"0" "01011" "011259" 1997
"0" "15154" "011259" 2003
"0" "01251" "011264" 1998
"0" "01251" "011264" 2000
"0" "05195" "011271" 1993
"0" "05195" "011271" 1996
"0" "01014" "011288" 1996
"0" "01014" "011288" 1998
"0" "01016" "011296" 1995
"0" "22922" "011296" 2000
"0" "22922" "011296" 2004
"0" "07768" "011296" 2005
"0" "19716" "011304" 2002
"0" "19716" "011304" 2005
"0" "05215" "011315" 2004
"0" "09645" "011323" 1994
"0" "03443" "011366" 1996
"0" "14994" "011399" 1999
"0" "17859" "011399" 2003
"0" "17859" "011399" 2005
"0" "01503" "011436" 1995
"0" "01944" "011450" 1997
"0" "01037" "011456" 1994
"0" "01396" "011456" 1999
"0" "01396" "011456" 2001
"0" "13405" "011462" 1999
"0" "13405" "011462" 2000
"0" "01437" "011506" 1998
"0" "01048" "011509" 1994
"0" "01048" "011509" 1999
"0" "01048" "011509" 2001
"0" "07705" "011511" 1996
"0" "08387" "011558" 1999
"0" "01047" "011559" 1993
"0" "07889" "011566" 1998
"0" "07896" "011566" 2001
"0" "07896" "011566" 2003
"0" "06112" "011584" 1995
"0" "11360" "011584" 1997
"0" "11360" "011584" 1998
"0" "18110" "011609" 2002
"0" "18110" "011609" 2005
"1" "19242" "011636" 2004
"0" "01057" "011649" 1994
"0" "12887" "011649" 1997
"0" "18385" "011649" 2000
"0" "18385" "011649" 2001
"0" "18385" "011649" 2005
"1" "15428" "011669" 2003
"0" "16958" "011672" 2005
"0" "11924" "011811" 1996
"0" "27456" "011910" 2003
"0" "27456" "011910" 2004
"1" "29821" "011944" 2005
"0" "07664" "011971" 1994
"0" "07664" "011971" 1995
"0" "00109" "011985" 1993
"0" "00109" "011985" 1996
"0" "12294" "011987" 1995
"0" "11850" "012123" 2003
"0" "27199" "012136" 2003
"1" "27208" "012142" 2001
"1" "27208" "012142" 2002
"0" "16917" "012189" 2001
"0" "25179" "012189" 2005
"0" "18500" "012256" 2000
"0" "18500" "012256" 2002
"0" "13763" "012338" 2004
"0" "09442" "012349" 1995
"0" "04546" "012389" 2000
"0" "04546" "012389" 2002
"0" "04546" "012389" 2003
"0" "14441" "012441" 2000
"0" "19762" "012459" 2000
"0" "28691" "012471" 2004
"0" "08892" "012516" 1994
"0" "08892" "012516" 1995
"0" "17269" "012545" 2005
"0" "05722" "012581" 1995
"0" "02338" "012631" 1998
"0" "04288" "012679" 2001
"0" "00697" "012734" 1995
"0" "04272" "012734" 1999
"0" "22172" "012734" 2003
"0" "22172" "012734" 2004
"0" "14309" "012788" 1999
"0" "05330" "012895" 2003
"0" "30097" "012950" 2004
"0" "10275" "013003" 2003
"0" "02129" "013011" 1995
"0" "19801" "013011" 2003
"0" "11058" "013070" 1995
"0" "01058" "013135" 1993
"0" "16989" "013369" 2000
"0" "16989" "013369" 2005
"0" "08647" "013381" 1995
"0" "20758" "013406" 2000
"0" "24079" "013406" 2003
"0" "04757" "013421" 1995
"0" "04757" "013421" 1996
"0" "27937" "013421" 2005
"0" "00936" "013554" 1994
"0" "05557" "013700" 2003
"0" "00023" "013708" 1993
"0" "06906" "013712" 1997
"0" "13027" "013714" 1997
"0" "13027" "013714" 2002
"0" "13027" "013714" 2005
"0" "00640" "013839" 1993
"0" "04425" "013842" 2000
"0" "04425" "013842" 2001
"0" "05355" "013990" 2005
"1" "20258" "014007" 2001
"1" "20258" "014007" 2004
"0" "03927" "014084" 1993
"0" "03927" "014084" 1995
"0" "03927" "014084" 1999
"0" "04284" "014264" 1995
"0" "17153" "014311" 2001
"0" "17153" "014311" 2002
"0" "17153" "014311" 2003
"0" "17153" "014311" 2005
"0" "00491" "014363" 1993
"0" "09955" "014364" 1994
"0" "06323" "014384" 2001
"0" "07146" "014385" 1997
"0" "20263" "014385" 2003
"0" "04766" "014418" 2003
"0" "04766" "014418" 2004
"0" "10547" "014450" 1998
"0" "10547" "014450" 2000
"0" "10547" "014450" 2001
"0" "10547" "014450" 2003
"0" "06861" "014466" 2000
"0" "06861" "014466" 2001
"0" "21126" "014535" 2003
"0" "00393" "014590" 2002
"0" "00393" "014590" 2003
"0" "12176" "014624" 2002
"0" "22758" "014624" 2005
"0" "17521" "014626" 2001
"0" "00138" "014650" 1993
"0" "00357" "014854" 1993
"0" "00719" "014878" 1993
"0" "00312" "014890" 1994
"0" "13840" "014895" 2001
"0" "07579" "014897" 1996
"0" "07684" "014918" 1993
"0" "05681" "014918" 1998
"0" "05681" "014918" 2002
"0" "00159" "015084" 1993
"0" "24367" "015106" 2005
"0" "01761" "015110" 2002
"0" "01761" "015110" 2003
"0" "00996" "015247" 1996
"0" "00996" "015247" 1999
"0" "00996" "015247" 2003
"0" "00996" "015247" 2004
"0" "20715" "015267" 2004
"0" "21638" "015290" 2002
"0" "09161" "015291" 1999
"0" "22110" "015291" 2004
"0" "22110" "015291" 2005
"0" "05189" "015360" 1997
"0" "00160" "015455" 1993
"0" "03619" "015708" 1996
"0" "03619" "015708" 1997
"0" "19772" "015855" 2001
"0" "01964" "016454" 1993
"0" "01964" "016454" 1997
"0" "14449" "016477" 2001
"0" "17195" "016531" 1999
"1" "16872" "016650" 1999
"0" "16871" "016650" 2001
"0" "16871" "016650" 2002
"1" "16872" "016650" 2004
"0" "08272" "016665" 1999
"0" "08272" "016665" 2003
"0" "04325" "016729" 1996
"0" "04328" "016729" 1997
"0" "27943" "017239" 2005
"0" "11146" "019398" 1995
"0" "12261" "020185" 1999
"0" "11593" "020548" 1995
"0" "11593" "020548" 1996
"0" "13146" "020548" 1999
"0" "07449" "020993" 1994
"0" "07449" "020993" 1995
"0" "17732" "021232" 2001
"0" "17732" "021232" 2003
"0" "13449" "021237" 1998
"0" "07429" "021237" 2002
"0" "01644" "021487" 1993
"0" "14119" "021519" 1997
"0" "14119" "021519" 2002
"0" "14119" "021519" 2005
"0" "06884" "021659" 1994
"0" "25429" "021659" 2005
"0" "07455" "021763" 1994
"1" "01869" "021828" 1993
"1" "01869" "021828" 1994
"0" "03263" "021828" 1998
"1" "23988" "021828" 1999
"1" "23988" "021828" 2000
"0" "15886" "022140" 2001
"0" "15886" "022140" 2002
"0" "15886" "022140" 2004
"0" "17813" "022207" 2002
"0" "00455" "022260" 1999
"0" "16863" "022260" 2002
"0" "16863" "022260" 2003
"0" "02526" "022325" 1997
"0" "02526" "022325" 2005
"0" "00389" "022615" 1994
"0" "00389" "022615" 1995
"0" "06513" "023084" 1996
"0" "06513" "023084" 1997
"0" "06513" "023084" 1999
"0" "06513" "023084" 2000
"0" "06513" "023084" 2003
"0" "17360" "023220" 2000
"0" "34379" "023291" 2003
"0" "20064" "023528" 2003
"0" "06742" "023605" 1995
"0" "04298" "023769" 1993
"0" "22758" "023809" 2003
"0" "22758" "023809" 2005
"0" "08443" "023810" 2004
"0" "22448" "023943" 2000
"0" "22448" "023943" 2001
"0" "00992" "023978" 1993
"0" "05007" "023988" 2001
"0" "08435" "024021" 2004
"0" "11513" "024032" 1995
"0" "11513" "024032" 1996
"0" "24758" "024032" 2002
"0" "11513" "024032" 2005
"0" "17608" "024198" 1998
"0" "03893" "024216" 1996
"0" "20985" "024216" 2002
"0" "20985" "024216" 2003
"0" "22698" "024219" 2000
"0" "22698" "024219" 2001
"0" "25266" "024224" 2002
"0" "25266" "024224" 2003
"0" "11495" "024381" 2002
"0" "13278" "024468" 2004
"0" "13278" "024468" 2005
"0" "15706" "024474" 1997
"0" "15706" "024474" 1999
"0" "15709" "024474" 2000
"0" "07693" "024522" 1995
"0" "11656" "024522" 2000
"0" "07990" "024530" 1994
"0" "07990" "024530" 1995
"0" "13658" "024538" 2000
"0" "13658" "024538" 2004
"0" "07940" "024655" 1997
"0" "20825" "024671" 2000
"0" "09551" "024723" 1994
"0" "12432" "024782" 2005
"0" "00407" "024870" 1998
"0" "24972" "024878" 2004
"0" "09271" "024910" 1993
"0" "09489" "024925" 1997
"0" "09489" "024925" 2000
"0" "08821" "024926" 1995
"0" "08821" "024926" 1996
"0" "06990" "024931" 1997
"0" "14027" "024975" 1999
"0" "14027" "024975" 2002
"0" "14027" "024975" 2004
"0" "14024" "024975" 2005
"0" "00167" "024978" 1995
"0" "21253" "024978" 2002
"0" "09141" "025021" 1996
"0" "07264" "025047" 1996
"0" "07264" "025047" 1999
"0" "07264" "025047" 2000
"0" "07264" "025047" 2001
"0" "07264" "025047" 2003
"0" "07264" "025047" 2004
"0" "22005" "025108" 2000
"0" "22005" "025108" 2002
"0" "08448" "025119" 1996
"0" "16454" "025124" 2001
"0" "23103" "025124" 2002
"0" "23103" "025124" 2005
"0" "28633" "025130" 2004
"0" "00914" "025157" 2002
"0" "07799" "025180" 2001
"0" "09380" "025186" 1997
"0" "01160" "025279" 2003
"0" "16742" "025313" 2000
"0" "16742" "025313" 2001
"0" "16742" "025313" 2002
"0" "00965" "025422" 1996
"0" "13422" "025434" 2002
"0" "06752" "025571" 1997
"0" "00334" "025573" 1994
"0" "07821" "025611" 1993
"0" "09113" "025647" 1995
"0" "24040" "025749" 2002
"0" "25176" "025777" 2005
"0" "23979" "025783" 2005
"0" "12036" "025807" 1997
"0" "08714" "025848" 1995
"0" "08714" "025848" 1997
"0" "12199" "025859" 2003
"0" "11247" "025870" 1996
"0" "11247" "025870" 2000
"0" "11256" "025870" 2001
"0" "11602" "025916" 1996
"0" "25886" "025980" 2003
"0" "25886" "025980" 2005
"0" "11307" "025983" 1993
"0" "08364" "026013" 1999
"0" "08364" "026013" 2000
"0" "08364" "026013" 2001
"0" "17580" "026021" 1996
"0" "17580" "026021" 2001
"0" "17580" "026021" 2003
"0" "09665" "027755" 1997
"0" "09665" "027755" 1998
"0" "18579" "027794" 1999
"0" "09783" "027895" 1994
"0" "09783" "027895" 1995
"0" "08358" "027903" 1998
"0" "19566" "027925" 2005
"0" "20241" "027928" 2000
"0" "20241" "027928" 2001
"0" "16397" "027937" 1997
"0" "16397" "027937" 1998
"0" "16397" "027937" 1999
"0" "16397" "027937" 2003
"0" "15560" "027938" 1999
"0" "15560" "027938" 2005
"0" "08581" "027957" 1997
"0" "06538" "027981" 1996
"0" "11793" "027981" 2004
"0" "15855" "028130" 1998
"0" "20080" "028145" 2001
"0" "11459" "028176" 2005
"0" "11577" "028180" 1999
"0" "17335" "028231" 1996
"0" "17335" "028231" 2000
"0" "12288" "028253" 1996
"0" "12288" "028253" 1998
"0" "12288" "028253" 1999
"0" "02202" "028320" 2002
"0" "02454" "028338" 1995
"0" "02454" "028338" 2000
"0" "23108" "028397" 2005
"1" "17460" "028414" 2005
"0" "07713" "028502" 2000
"0" "11564" "028533" 1995
"0" "06721" "028556" 1994
"0" "06721" "028556" 1996
"0" "06721" "028556" 1998
"0" "07645" "028596" 1994
"0" "07645" "028596" 1996
"0" "18069" "028616" 2002
"0" "18069" "028616" 2005
"0" "26823" "028648" 2002
"0" "26823" "028648" 2005
"0" "17554" "028700" 1999
"0" "13718" "028742" 2000
"0" "19392" "028742" 2005
"0" "20993" "028930" 2001
"0" "13152" "028940" 2002
"0" "10713" "029015" 2005
"0" "20511" "029021" 1997
"0" "13978" "029085" 2000
"0" "15638" "029095" 1996
"0" "15638" "029095" 2000
"0" "15638" "029095" 2001
"0" "15392" "029127" 1997
"0" "23532" "029127" 2005
"0" "08499" "029133" 1996
"0" "20009" "029133" 2001
"0" "20009" "029133" 2004
"0" "27845" "029173" 2002
"0" "16621" "029173" 2004
"0" "14237" "029287" 2000
"0" "14788" "029345" 2002
"0" "14788" "029345" 2003
"0" "17648" "029356" 2000
"0" "12074" "029381" 1997
"0" "12074" "029381" 2000
"0" "18450" "029386" 1998
"0" "01603" "029392" 2000
"0" "21019" "029392" 2002
"0" "21019" "029392" 2004
"0" "21019" "029392" 2005
"0" "25795" "029435" 2004
"0" "14681" "029511" 1998
"0" "14681" "029511" 2002
"0" "13772" "029710" 1997
"0" "25033" "029736" 2003
"0" "18845" "029751" 2005
"0" "13073" "029900" 2001
"0" "17946" "029901" 1997
"0" "15688" "029942" 2002
"0" "13552" "029968" 1999
"0" "13552" "029968" 2000
"0" "13552" "029968" 2001
"0" "20752" "030231" 2004
"0" "20752" "030231" 2005
"0" "34291" "030399" 2002
"0" "34290" "030399" 2003
"0" "16866" "030598" 2000
"0" "15912" "030671" 1997
"0" "11934" "031022" 1995
"0" "11507" "031166" 1995
"0" "11507" "031166" 1999
"0" "13490" "031223" 1996
"0" "13490" "031223" 1998
"0" "13595" "061552" 2003
"0" "28298" "061557" 2002
"0" "28298" "061557" 2004
"0" "17879" "061567" 2005
"0" "29465" "061570" 2004
"0" "13558" "061596" 1997
"0" "13558" "061596" 1999
"0" "13559" "061596" 2004
"0" "13559" "061596" 2005
"0" "26385" "061676" 2005
"0" "28900" "061732" 2004
"0" "28900" "061732" 2005
"0" "35006" "061900" 2005
"0" "20541" "061996" 1999
"0" "20541" "061996" 2003
"0" "13798" "062036" 2001
"1" "20577" "062215" 1999
"0" "19147" "062266" 2004
"0" "15191" "062391" 2002
"0" "18315" "062590" 1998
"0" "12142" "062599" 1999
"0" "14607" "062634" 2000
"0" "15386" "062667" 2002
"0" "15386" "062667" 2004
"0" "22495" "062686" 2001
"0" "22495" "062686" 2004
"0" "18137" "062732" 1999
"0" "18137" "062732" 2003
"0" "17500" "062784" 2000
"0" "29410" "064766" 2005
"0" "20496" "064853" 2000
"0" "23879" "064942" 2001
"0" "18147" "065009" 2000
"0" "18147" "065009" 2002
"0" "09666" "065026" 2002
"0" "09666" "065026" 2005
"1" "13750" "065105" 1998
"1" "13750" "065105" 2000
"1" "13750" "065105" 2002
"0" "13751" "065105" 2005
"0" "04323" "065156" 1996
"0" "04323" "065156" 2000
"0" "04323" "065156" 2002
"0" "04323" "065156" 2003
"0" "14103" "065399" 2000
"0" "18741" "112178" 2000
"0" "12537" "113419" 2003
"1" "05706" "114524" 2000
"0" "20601" "116503" 1999
"0" "14051" "116526" 2002
"0" "04347" "118121" 2005
"0" "28732" "145049" 2004
"1" "23088" "145308" 2005
"0" "34518" "146171" 2005

end

Thank you for your time,

Marc

[Emil Alnor]

The following code lowercases your variables, as I think this is easier to work with. Assuming that gender is 0 when the ceo is male, mm is 1 when there is a male-to-male ceo-transition, mf is 1 when there is a male-to-female transition, ff is female-to-female, and fm is female-to-male

ren *, lower
sort gvkey year
destring ge, replace

gen mm = ge[_n-1]==0 & ge==0 & exe!=exe[_n-1] & gvkey==gvkey[_n-1]
gen mf = ge[_n-1]==0 & ge==1 & exe!=exe[_n-1] & gvkey==gvkey[_n-1]
gen ff = ge[_n-1]==1 & ge==1 & exe!=exe[_n-1] & gvkey==gvkey[_n-1]
gen fm = ge[_n-1]==1 & ge==0 & exe!=exe[_n-1] & gvkey==gvkey[_n-1]

[Marc Pascual]

Thank Emil! I created them properly but when I try to run a regression with it I get the following:
xtreg acquisitions mf i.fyear size PPE market_to_book, fe
note: mf omitted because of collinearity.
note: 1994.fyear omitted because of collinearity.
note: 1995.fyear omitted because of collinearity.
note: 1996.fyear omitted because of collinearity.
note: 1997.fyear omitted because of collinearity.
note: 1998.fyear omitted because of collinearity.
note: 1999.fyear omitted because of collinearity.
note: 2000.fyear omitted because of collinearity.
note: 2001.fyear omitted because of collinearity.
note: 2002.fyear omitted because of collinearity.
note: 2003.fyear omitted because of collinearity.
note: 2004.fyear omitted because of collinearity.
note: 2005.fyear omitted because of collinearity.

Fixed-effects (within) regression Number of obs = 1,095
Group variable: fyear Number of groups = 13

R-squared: Obs per group:
Within = 0.0291 min = 55
Between = 0.0263 avg = 84.2
Overall = 0.0287 max = 121

F(3,1079) = 10.80
corr(u_i, Xb) = -0.0212 Prob > F = 0.0000

--------------------------------------------------------------------------------
acquisitions | Coefficient Std. err. t P>|t| [95% conf. interval]
---------------+----------------------------------------------------------------
mf | 0 (omitted)
|
fyear |
1994 | 0 (omitted)
1995 | 0 (omitted)
1996 | 0 (omitted)
1997 | 0 (omitted)
1998 | 0 (omitted)
1999 | 0 (omitted)
2000 | 0 (omitted)
2001 | 0 (omitted)
2002 | 0 (omitted)
2003 | 0 (omitted)
2004 | 0 (omitted)
2005 | 0 (omitted)
|
size | 5.89e-06 3.89e-06 1.51 0.131 -1.75e-06 .0000135
PPE | -.1714867 .0315655 -5.43 0.000 -.2334235 -.1095499
market_to_book | -.0071176 .0204588 -0.35 0.728 -.0472611 .0330259
_cons | 1.279761 .1969666 6.50 0.000 .8932803 1.666242
---------------+----------------------------------------------------------------
sigma_u | .18073167
sigma_e | 1.9807471
rho | .00825676 (fraction of variance due to u_i)
--------------------------------------------------------------------------------
F test that all u_i=0: F(12, 1079) = 0.81 Prob > F = 0.6436

Any tips?