Hi, I'm doing a tracking analysis of executive changes. In the dataset, I divide the positions into CEO, CFO, and others. I only want to track the most current title of each executive and the title of the last company. For example, A worked in company 1 in 1992-1994, and in company2 in 1995-1998, and in company 3 in 1999-2002. I want to know A's title in 2002 (company 3) and title in 1998 (company2).

Follow the coding of this post , I can create a column including the current title, but I want to know how to track the title of the last company. Thank you!

Below is a sample of my dataset.

[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input long gvkey int year long execid float(ceo cfo other)
10553 1992 2 1 0 0
10553 1993 2 1 0 0
10553 1994 2 1 0 0
10553 1995 2 1 0 0
10553 1996 2 1 0 0
10553 1997 2 1 0 0
10553 1998 2 1 0 0
10553 1999 2 1 0 0
10553 2000 2 1 0 0
132502 1998 2 0 0 1
132502 1999 2 0 0 1
132502 2001 2 0 0 1
132502 2002 2 0 0 1
132502 2003 2 0 0 1
1246 1992 19 0 0 1
1246 1993 19 0 0 1
1246 1994 19 0 0 1
64117 1996 19 1 0 0
64117 1997 19 1 0 0
64117 1998 19 1 0 0
9563 1992 28 1 0 0
9563 1993 28 1 0 0
9563 1994 28 1 0 0
28349 1992 28 1 0 0
28349 1993 28 1 0 0
28349 1994 28 1 0 0
1543 1992 47 1 0 0
1543 1993 47 1 0 0
1543 1994 47 1 0 0
1543 1995 47 1 0 0
4990 2000 47 0 0 1
4990 2001 47 0 0 1
4990 2002 47 0 0 1
1581 1992 51 1 0 0
1581 1993 51 1 0 0
1581 1994 51 1 0 0
1581 1995 51 1 0 0
1581 1996 51 1 0 0
1581 1997 51 1 0 0
1372 2001 75 1 0 0
1372 2002 75 1 0 0
1372 2003 75 1 0 0
1786 1992 75 1 0 0
1786 1993 75 1 0 0
1786 1994 75 1 0 0
1786 1995 75 1 0 0
1786 1996 75 1 0 0
1786 1997 75 1 0 0
1786 1998 75 1 0 0
3502 2006 75 1 0 0
1848 1992 83 0 0 1
1848 1993 83 0 0 1
1848 1994 83 0 0 1
1848 1995 83 0 0 1
113491 1998 83 0 0 1
113491 1999 83 0 0 1
113491 2000 83 0 0 1
2111 1992 116 1 0 0
2111 1993 116 1 0 0
2111 1994 116 1 0 0
7257 1994 116 1 0 0
7257 1995 116 1 0 0
7257 1996 116 1 0 0
7257 1997 116 1 0 0
7257 1998 116 1 0 0
7257 1999 116 1 0 0
7257 2000 116 1 0 0
7257 2001 116 1 0 0
7257 2002 116 1 0 0
7257 2003 116 1 0 0
7257 2004 116 1 0 0
7257 2005 116 1 0 0
7620 1992 119 0 0 1
7620 1993 119 0 0 1
7620 1994 119 0 0 1
7620 1995 119 0 0 1
7620 1996 119 0 0 1
64135 1996 119 0 0 1
64135 1997 119 0 0 1
64135 1998 119 0 0 1
64135 1999 119 0 0 1
64135 2000 119 0 0 1
64135 2001 119 0 0 1
64135 2002 119 0 0 1
64135 2003 119 0 0 1
64135 2004 119 0 0 1
64135 2005 119 0 0 1
64135 2006 119 0 0 1
2424 1992 152 1 0 0
2424 1993 152 1 0 0
2424 1994 152 1 0 0
2424 1995 152 1 0 0
2424 1996 152 1 0 0
2424 1997 152 1 0 0
6799 2001 152 1 0 0
6799 2002 152 1 0 0
6799 2003 152 1 0 0
6799 2004 152 1 0 0
6799 2006 152 1 0 0
2490 1992 158 0 0 1
end