Dear all,
I would like to merge some spell format .dta into the Target panel (Cohort 6).
I am thinking about shrinking information within each year (different spells nested in one wave), in order to merge the information with the target panel .dta. However, before doing so, I need to assign each status to the year when that status actually accurred, and not to the year it was recorded by the interviewer (what the wave variable does). Has anyone got suggestions on how to make this step?
Thank you very much.
Best wishes,
Giovanni
Hi Giovanni,
Year and month of the episodes duration are recorded in separate variables (not in „wave“). Depends on the spell file though, e.g. in spEmp you would find ts2311 and ts2312 for start and end dates.
Dear Tobias,
yes, thanks a lot. I am indeed using spEmp. I am now trying to implement the following procedure in Stata. I first drop subspell=!0, I drop subspell==0 & spext==1, and also drop if spms==-20.
Afterwards, I only keep employment spells that end in or after 2007 (the year Target panel starts). This is because I want to merge SpEmp in Target panel, and make the final dataset a prospective panel dataset.
Got to this point, I notice that many individuals only have one employment spell each, mostly lasting no much longer than one or two years. In some cases, ts2312c records that the spell is ongoing, but does the ‚ongoing‘ status mean the person is employed until no other spell is recorded, or does it simply mean the spell is ongoing at the time of a given wave? I ask because I see that sometimes, ts2312c states that the spell is ongoing despite ts2312y providing an end year for the employment spell.
I remain at your convenience should anything be unclear.
Thank you very much
Giovanni
yes, you are right, „ongoing“ means: the spell is still ongoing at the time of the interview. The end then is set to the date of the interview. If newer information about that specific episodes is collected (in later waves), this is recorded in a separate subspell. All subspells are then harmonized in subspell=0.
You can read more about all of this stuff at chapter 4.4 (p. 48) in the DataManual of SC6, where this is thoroughly explained.