Project

General

Profile

Support #1642

Incomplete Merge of Longitudinal individual indresp variables (a - k; 1 - 11) and longitudinal hhresp variables - Unmatched Data both ways

Added by Sue Easton over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Data management
Start date:
01/28/2022
% Done:

100%

Description

Hi,

I have merged (appended) core individual variables from all UKHLS indresp waves a - k (1 - 11) longitudinally, and all waves of core household vars from hhresp longitudinally. Both files have data from all 11 waves.

But when I merge these longitudinal indresp with hhresp datasets many to one (m:1) on hidp, there is unmatched data from both the indresp and hhresp datasets, which I wasn't really expecting. (My code is good, I've done this before).

Can someone explain why this might be so that I understand what's going on with the data before I continue my analysis please? I.e. are there people who have answered the household questions (such as proxy respondents), but who have not completed the individual questionnaires?

Also if this is documented somewhere please can you direct me to where I can find the answers to this sort of question.

Many thanks for your help! Much appreciated!

#1

Updated by Understanding Society User Support Team over 2 years ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 80

Hello Sue,

While attempt is made that all enumerated/responding households complete the household questionnaire, there are some cases where this does not happen. So, you will have individual respondents in indresp but no record in hhresp. Such cases are higher after Wave 5.

It is also possible that someone in an enumerated/responding household completed the household questionnaire, but none of the adults participated in an adult interview (proxy or full). So, there will be households not represented in indresp.

Hope this helps.

Best wishes,
Understanding Society User Support Team

#2

Updated by Understanding Society User Support Team over 2 years ago

  • Private changed from Yes to No
#3

Updated by Understanding Society User Support Team over 2 years ago

  • Category set to Data management
  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100

Also available in: Atom PDF