Support #1642: Incomplete Merge of Longitudinal individual indresp variables (a - k; 1 - 11) and longitudinal hhresp variables - Unmatched Data both ways - Understanding Society User Support

Actions

Copy link

Support #1642

open

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

Added by Sue Easton almost 3 years ago. Updated almost 3 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!

Actions

Copy link

Updated by Understanding Society User Support Team almost 3 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

Actions

Copy link