Understanding Society User Support

Creation of a unique calendar year for which information has been collected for a person*year dataset?

Hi. Could you please help create a unique calendar year for each wave when the individual respondent is interviewed? I would like to combine indresp data from all waves in a long, person*year format.

The calendar year should reflect the year for which the information is collected. I’m interested in UKHLS wave 1-13 data, birth cohorts 1983-1997. I tried interview date intdaty_dv, but some respondents have had two interviews in one year from different waves. Please see the example table:

I tried deriving the calendar year from the interview date, for instance, when the month intdatm_dv is earlier than June or July, but with no luck. I still have many double calendar years for each respondent.

I appreciate your consideration!

Best,
Remigiusz Zulicki