Support #1368
Unmatched households when merging hhresp with lsoa data
Added by Natalie Bennett almost 4 years ago.
Updated over 2 years ago.
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
- Category set to Special license
- Assignee set to Natalie Bennett
- Target version set to X M
- % Done changed from 0 to 80
- Private changed from Yes to No
Hi Natalie,
the universe of cases in the geographical identifier datasets is sampled households with a valid postcode on the ONS Postcode Directory, see the user guidance accompanying the file. Not all sampled households have a valid postcode, and not all sampled households participate in the household interview. The hhresp data file only has households with a household interview record.
Hope this explains the non-matches you find.
Best wishes,
Gundi
- Status changed from New to Feedback
To follow up on what Gundi has said,
All households in c_hhsamp who have a valid postcode for their addresses are available in c_lsoa11_protect file. c_hhresp comprises of only those sampled households who have completed a household questionnaire, so the 6507 cases in c_lsoa11_protect are those households who are present in c_hhsamp but not in c_hhresp. The 7 cases in c_hhresp but no in c_lsoa11_protect are households without a valid postcode.
You can check this by merging c_hhsamp with c_lsoa11_protect using c_hidp. You will find that there are no cases in the c_lsoa11_protect which are not in c_hhsamp, but there are 2898 cases in c_hhsamp which are not in c_lsoa11_protect.
Note, c_hhsamp c_hhresp c_lsoa11_protect are all at c_hidp level, so m:1 merging is not needed. You can use 1:1 merging.
Best wishes,
Alita
On behalf of Understanding Society User Support Team
Hi Alita and Gundi
Thanks both for your help, I understand the source of the non-matches now.
Thanks so much.
Best wishes
Natalie
Sorry just to follow up so I can justify this later, could you confirm why those 2,898 cases are not in the LSOA file?
Many thanks
Natalie
Hi Natalie,
These are the households without valid postcodes.
Best wishes,
Alita
- Status changed from Feedback to Resolved
- Assignee deleted (
Natalie Bennett)
- % Done changed from 80 to 100
Also available in: Atom
PDF
Updated by Gundi Knies 
Updated by 
Updated by 
Updated by