Project

General

Profile

Actions

Support #2144

open

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

Added by Remigiusz Żulicki 28 days ago. Updated 16 days ago.

Status:
Feedback
Priority:
Normal
Category:
Data documentation
Start date:
09/06/2024
% Done:

80%


Description

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:

pidp intdaty_dv intdatm_dv wave age_dv doby_dv
------------- ------------------- ------------------- ------------- --------------- ----------------
1558565 2011 1 2 17 1993
1558565 2011 12 3 18 1993
476598415 2020 1 11 25 1994
476598415 2020 7 12 26 1994

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

Actions #1

Updated by Understanding Society User Support Team 23 days ago

  • Category changed from Harmonisation to Data documentation
  • Status changed from New to Feedback
  • % Done changed from 0 to 50
  • Private changed from Yes to No

Hello Remigiusz

This process is not entirely straightforward. For instance, due to overlapping interviews, you will need to make some decisions about whom to include. Understanding Society has produced Calendar Year Datasets for 2020 and 2021. I recommend reviewing the Understanding Society: Calendar Year Dataset, 2020 User Guide, particularly Section 2 on Data Structure, as it provides useful guidance for creating your dataset.

Here is the link for:

I hope this information is helpful.

Best wishes,
Roberto Cavazos
Understanding Society User Support Team

Actions #2

Updated by Understanding Society User Support Team 16 days ago

  • % Done changed from 50 to 80
Actions

Also available in: Atom PDF