https://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382020-06-25T16:28:46ZUnderstanding Society User SupportUnderstanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=51212020-06-25T16:28:46ZGundi Kniesgknies@essex.ac.uk
<ul><li><strong>Category</strong> set to <i>Special license</i></li><li><strong>Assignee</strong> set to <i>Natalie Bennett</i></li><li><strong>Target version</strong> set to <i>X M</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>80</i></li><li><strong>Private</strong> changed from <i>Yes</i> to <i>No</i></li></ul><p>Hi Natalie,<br />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.</p>
<p>Hope this explains the non-matches you find.<br />Best wishes,<br />Gundi</p> Understanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=51302020-06-26T00:19:48ZAlita Nandi
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Feedback</i></li></ul><p>To follow up on what Gundi has said,</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>Best wishes,<br />Alita<br />On behalf of Understanding Society User Support Team</p> Understanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=51412020-06-26T13:18:05ZNatalie Bennett
<ul></ul><p>Hi Alita and Gundi</p>
<p>Thanks both for your help, I understand the source of the non-matches now.</p>
<p>Thanks so much.</p>
<p>Best wishes</p>
<p>Natalie</p> Understanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=51432020-06-26T15:38:14ZNatalie Bennett
<ul></ul><p>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?</p>
<p>Many thanks</p>
<p>Natalie</p> Understanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=51482020-06-27T10:07:42ZAlita Nandi
<ul></ul><p>Hi Natalie,</p>
<p>These are the households without valid postcodes.</p>
<p>Best wishes,<br />Alita</p> Understanding Society User Support - Support #1368: Unmatched households when merging hhresp with lsoa datahttps://iserredex.essex.ac.uk/support/issues/1368?journal_id=64222021-10-13T10:35:24ZUnderstanding Society User Support Teamusersupport@understandingsociety.ac.uk
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Resolved</i></li><li><strong>Assignee</strong> deleted (<del><i>Natalie Bennett</i></del>)</li><li><strong>% Done</strong> changed from <i>80</i> to <i>100</i></li></ul>