Hi everyone,

I want to create CEO’s tenure based on “Date become CEO” and “Date left as CEO”. My problem is how to create a progressive tenure variable?

gen tenure = (BECAMECEO – LEFTOFC)/365

next, I want to create a progressive tenure variable:

For example: firm: 1004 in 2002 has CEO with a tenure of 21.65 and CEO’s tenure will increase in 2003 = 21.65 + 1 = 22.65, 2004 = 23.65, and following years, so how I can code CEO’s tenure after 2002? (P/S: to verify CEOs of a firm, I used the variables: EXECID and CEOANN). Thank you.

* Example generated by -dataex-. To install: ssc install dataex
clear
input double(gvkey fyear) str50 EXEC_FULLNAME str4 CEOANN double AGE str6 EXECID long(BECAMECEO LEFTOFC) str6 GENDER float tenure
1004 2002 "David P. Storch" "CEO" 50 "09249" 13431 21335 "MALE" 21.654795
1004 2003 "David P. Storch" "CEO" 51 "09249" 13431 21335 "MALE" 21.654795
1004 2004 "David P. Storch" "CEO" 52 "09249" 13431 21335 "MALE" 21.654795
1004 2005 "David P. Storch" "CEO" 53 "09249" 13431 21335 "MALE" 21.654795
1004 2006 "David P. Storch" "CEO" 54 "09249" 13431 21335 "MALE" 21.654795
1004 2007 "David P. Storch" "CEO" 55 "09249" 13431 21335 "MALE" 21.654795
1004 2008 "David P. Storch" "CEO" 56 "09249" 13431 21335 "MALE" 21.654795
1004 2009 "David P. Storch" "CEO" 57 "09249" 13431 21335 "MALE" 21.654795
1004 2010 "David P. Storch" "CEO" 58 "09249" 13431 21335 "MALE" 21.654795
1004 2011 "David P. Storch" "CEO" 59 "09249" 13431 21335 "MALE" 21.654795
1004 2012 "David P. Storch" "CEO" 60 "09249" 13431 21335 "MALE" 21.654795
1004 2013 "David P. Storch" "CEO" 61 "09249" 13431 21335 "MALE" 21.654795
1004 2014 "David P. Storch" "CEO" 62 "09249" 13431 21335 "MALE" 21.654795
1004 2015 "David P. Storch" "CEO" 63 "09249" 13431 21335 "MALE" 21.654795
1004 2016 "David P. Storch" "CEO" 64 "09249" 13431 21335 "MALE" 21.654795
1034 2002 "Jeffrey E. Smith" "" . "06392" 11688 12570 "MALE" 2.416438
1034 2003 "Ingrid Wiik" "CEO" 59 "11170" 14610 16982 "FEMALE" 6.49863
1034 2004 "Ingrid Wiik" "CEO" 60 "11170" 14610 16982 "FEMALE" 6.49863
1034 2005 "Ingrid Wiik" "CEO" 61 "11170" 14610 16982 "FEMALE" 6.49863
1034 2006 "Ingrid Wiik" "" . "11170" 14610 16982 "FEMALE" 6.49863
1038 2002 "" "" . "" . . "" .
1045 2001 "Robert W. Baker" "" . "03660" . . "MALE" .
1045 2002 "Robert W. Baker" "" . "03660" . . "MALE" .
1045 2003 "Donald J. Carty" "" . "03661" 14019 15819 "MALE" 4.931507
1045 2004 "Gerard J. Arpey" "CEO" 46 "14591" 15820 18959 "MALE" 8.6
1045 2005 "Gerard J. Arpey" "CEO" 47 "14591" 15820 18959 "MALE" 8.6
1045 2006 "Gerard J. Arpey" "CEO" 48 "14591" 15820 18959 "MALE" 8.6
1045 2007 "Gerard J. Arpey" "CEO" 48 "14591" 15820 18959 "MALE" 8.6
1045 2008 "Gerard J. Arpey" "CEO" 49 "14591" 15820 18959 "MALE" 8.6
1045 2009 "Gerard J. Arpey" "CEO" 50 "14591" 15820 18959 "MALE" 8.6
1045 2010 "Gerard J. Arpey" "CEO" 51 "14591" 15820 18959 "MALE" 8.6
1045 2011 "Gerard J. Arpey" "CEO" 52 "14591" 15820 18959 "MALE" 8.6
1045 2014 "Derek J. Kerr" "" 49 "46189" . . "MALE" .
1045 2015 "Derek J. Kerr" "" 50 "46189" . . "MALE" .
1045 2016 "Derek J. Kerr" "" 51 "46189" . . "MALE" .
end
format %td BECAMECEO
format %td LEFTOFC
[/CODE]