I am trying to create a variable for "Years of Employment Experience" for use in a panel data set.
My data are individuals observed of a period of 18 years, 1991 to 2009.
I have data of when each employment spell started (year), and when it ended (year) for each individual (identified by an ID number variable) as well as the year the individual was interviewed (in the main data set, which is separate).
I have managed to add up total employment spells across the individual's lifetime so far, but need to transfer this to the panel data.
I am try to create a ‘cumulative experience’ variable so that the spells of employment are only summed up to the year of interview.
Can this be done using survival time commands, or if not, what would be the best way to proceed?
Any help would be much appreciated.
Many thanks!
Ella
My data are individuals observed of a period of 18 years, 1991 to 2009.
I have data of when each employment spell started (year), and when it ended (year) for each individual (identified by an ID number variable) as well as the year the individual was interviewed (in the main data set, which is separate).
I have managed to add up total employment spells across the individual's lifetime so far, but need to transfer this to the panel data.
I am try to create a ‘cumulative experience’ variable so that the spells of employment are only summed up to the year of interview.
Can this be done using survival time commands, or if not, what would be the best way to proceed?
Any help would be much appreciated.
Many thanks!
Ella
Comment