I have this 30 year panel data with he name and identifier of executives. I also have the firm which they worked as a CEO:
I
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str50 EXEC_FULLNAME str6 execid long gvkey double fyear long(BECAMECEO leftceo) "A. Blaine Bowman" "09084" 3971 1992 7305 15553 "A. Blaine Bowman" "09084" 3971 1993 7305 15553 "A. Blaine Bowman" "09084" 3971 1994 7305 15553 "A. Blaine Bowman" "09084" 3971 1995 7305 15553 "A. Blaine Bowman" "09084" 3971 1996 7305 15553 "A. Blaine Bowman" "09084" 3971 1997 7305 15553 "A. Blaine Bowman" "09084" 3971 1998 7305 15553 "A. Blaine Bowman" "09084" 3971 1999 7305 15553 "A. Blaine Bowman" "09084" 3971 2000 7305 15553 "A. Blaine Bowman" "09084" 3971 2001 7305 15553 "A. Blaine Bowman" "09084" 3971 2002 7305 15553 "A. Blaine Bowman" "09084" 3971 2003 7305 15553 "A. Dan Rovig" "09998" 14011 1992 10897 13741 "A. Dan Rovig" "09998" 14011 1993 10897 13741 "A. Dan Rovig" "09998" 14011 1994 10897 13741 "A. Dan Rovig" "09998" 14011 1995 10897 13741 "A. Dan Rovig" "09998" 14011 1996 10897 13741 "A. Dan Rovig" "09998" 14011 1997 10897 13741 "A. Dan Rovig" "09998" 14011 1998 10897 13741 "A. Dano Davis" "01044" 11535 1992 8036 14571 "A. Dano Davis" "01044" 11535 1993 8036 14571 "A. Dano Davis" "01044" 11535 1994 8036 14571 "A. Dano Davis" "01044" 11535 1995 8036 14571 "A. Dano Davis" "01044" 11535 1996 8036 14571 "A. Dano Davis" "01044" 11535 1997 8036 14571 "A. Dano Davis" "01044" 11535 1998 8036 14571 "A. Dano Davis" "01044" 11535 1999 8036 14571 "A. Dano Davis" "01044" 11535 2000 8036 14571 "A. Dano Davis" "01044" 11535 2001 8036 14571 "A. Drue Jennings" "00521" 6334 1992 10227 14975 "A. Drue Jennings" "00521" 6334 1993 10227 14975 "A. Drue Jennings" "00521" 6334 1994 10227 14975 "A. Drue Jennings" "00521" 6334 1995 10227 14975 "A. Drue Jennings" "00521" 6334 1996 10227 14975 "A. Drue Jennings" "00521" 6334 1997 10227 14975 "A. Drue Jennings" "00521" 6334 1998 10227 14975 "A. Drue Jennings" "00521" 6334 1999 10227 14975 "A. Drue Jennings" "00521" 6334 2000 10227 14975 "A. Drue Jennings" "00521" 6334 2001 10227 14975 "A. E. Benton" "09161" 15291 1992 10471 14487 "A. E. Benton" "09161" 15291 1993 10471 14487 "A. E. Benton" "09161" 15291 1994 10471 14487 "A. E. Benton" "09161" 15291 1995 10471 14487 "A. E. Benton" "09161" 15291 1996 10471 14487 "A. E. Benton" "09161" 15291 1997 10471 14487 "A. E. Benton" "09161" 15291 1998 10471 14487 "A. E. Benton" "09161" 15291 1999 10471 14487 "A. Earl Swift" "20162" 10221 1997 6940 15103 "A. Earl Swift" "20162" 10221 1998 6940 15103 "A. Earl Swift" "20162" 10221 1999 6940 15103 "A. Earl Swift" "20162" 10221 2000 6940 15103 "A. Earl Swift" "20162" 10221 2001 6940 15103 "A. Eugene Sapp, Jr." "08170" 9313 1992 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1993 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1994 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1995 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1996 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1997 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1998 14426 . "A. Eugene Sapp, Jr." "08170" 9313 1999 14426 . "A. Eugene Sapp, Jr." "08170" 9313 2000 14426 . "A. F. Petrocelli" "01866" 8750 1998 14152 . "A. F. Petrocelli" "01866" 8750 1999 14152 . "A. F. Petrocelli" "01866" 8750 2000 14152 . "A. F. Petrocelli" "01866" 8750 2001 14152 . "A. F. Petrocelli" "01866" 8750 2002 14152 . "A. F. Petrocelli" "01866" 8750 2003 14152 . "A. Frederick Gerstell" "04777" 2633 1992 11323 . "A. Frederick Gerstell" "04777" 2633 1993 11323 . "A. Frederick Gerstell" "04777" 2633 1994 11323 . "A. Frederick Gerstell" "04777" 2633 1995 11323 . "A. Frederick Gerstell" "04777" 2633 1996 11323 . "A. Frederick Gerstell" "04777" 2633 1997 11323 . "A. George (Skip) Battle" "21965" 121834 2000 14945 16070 "A. George (Skip) Battle" "21965" 121834 2001 14945 16070 "A. George (Skip) Battle" "21965" 121834 2002 14945 16070 "A. George (Skip) Battle" "21965" 121834 2003 14945 16070 "A. George (Skip) Battle" "21965" 121834 2004 14945 16070 "A. J. C. Smith" "00589" 7065 1992 11688 14549 "A. J. C. Smith" "00589" 7065 1993 11688 14549 "A. J. C. Smith" "00589" 7065 1994 11688 14549 "A. J. C. Smith" "00589" 7065 1995 11688 14549 "A. J. C. Smith" "00589" 7065 1996 11688 14549 "A. J. C. Smith" "00589" 7065 1997 11688 14549 "A. J. C. Smith" "00589" 7065 1998 11688 14549 "A. J. C. Smith" "00589" 7065 1999 11688 14549 "A. James Dearlove" "27982" 8440 2002 13270 18748 "A. James Dearlove" "27982" 8440 2003 13270 18748 "A. James Dearlove" "27982" 8440 2004 13270 18748 "A. James Dearlove" "27982" 8440 2005 13270 18748 "A. James Dearlove" "27982" 8440 2006 13270 18748 "A. James Dearlove" "27982" 8440 2007 13270 18748 "A. James Dearlove" "27982" 8440 2008 13270 18748 "A. James Dearlove" "27982" 8440 2009 13270 18748 "A. James Dearlove" "27982" 8440 2010 13270 18748 "A. James Dearlove" "27982" 8440 2011 13270 18748 "A. Jayson Adair" "17946" 29901 1997 18294 . "A. Jayson Adair" "17946" 29901 1998 18294 . "A. Jayson Adair" "17946" 29901 1999 18294 . "A. Jayson Adair" "17946" 29901 2000 18294 . end format %td BECAMECEO format %td leftceo
Do you have any tips on how to proceed?
First thought was to create a new variable and use carryforward, but in this case carryforward has to stop in the year of "leftCEO"
Many thanks for your time
0 Response to Create a new indicator
Post a Comment