Incomplete Merge of Longitudinal individual indresp variables (a - k; 1 - 11) and longitudinal hhresp variables - Unmatched Data both ways
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!
Updated by Understanding Society User Support Team 6 months ago
- Status changed from New to Feedback
- % Done changed from 0 to 80
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.
Understanding Society User Support Team