Project

General

Profile

Support #1368

Unmatched households when merging hhresp with lsoa data

Added by Natalie Bennett over 2 years ago. Updated about 1 year ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Special license
Start date:
06/23/2020
% Done:

100%


Description

Hi I am trying to distribute LSOA identifiers to household level data using wave 3. I have an issue when I merge the c_hhresp file with the c_lsoa11_protect file using the below stata code:

use c_hhresp.dta, clear
merge m:1 c_hidp using c_lsoa11_protect.dta

When performing this command I find 7 households from the hhresp file which are not found in the LSOA file, and 6,507 households from the LSOA file not found in the hhresp file.

I haven't been able to identify a reason from looking at the data as to why these data are only found in one file, rather than both. I was wondering if you could confirm if the above merge is correct and if so, what the reason is for these data which cannot be matched?

Many thanks

Natalie

Also available in: Atom PDF