https://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382020-07-20T05:21:57ZUnderstanding Society User SupportUnderstanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52072020-07-20T05:21:57ZAlita Nandi
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Feedback</i></li><li><strong>Assignee</strong> changed from <i>Stephanie Auty</i> to <i>Clara Mascaro</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>50</i></li></ul><p>Hi Clara,</p>
<p>Our data team has looked into this and found the number of individuals in w_indresp for whom a matched LAD is not available in the w_oslaua files, are 57, 10, 19, 25, 7, 14, 15, 20. The corresponding numbers for individuals in w_indall and w_oslaua are 0,91, 23, 36, 49, 17, 17, 28, 44.</p>
<p>Is that what you find? If not, please let us know the names of the files you merged, and the number of unmatched cases you found.</p>
<p>Best wishes,<br />Alita<br />On behalf of Understanding Society User Support Team</p> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52082020-07-20T05:22:05ZAlita Nandi
<ul><li><strong>Private</strong> changed from <i>Yes</i> to <i>No</i></li></ul> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52092020-07-20T05:31:17ZAlita Nandi
<ul></ul><p>And for these unmatched cases we found gor_dv and country were missing, as is expected since their postcodes were missing which resulted in missing LAs.</p> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52102020-07-21T15:30:37ZClara Mascaro
<ul></ul><p>Alita Nandi wrote:</p>
<blockquote>
<p>And for these unmatched cases we found gor_dv and country were missing, as is expected since their postcodes were missing which resulted in missing LAs.</p>
</blockquote>
<p>Hi Alita,</p>
<p>Thanks very much for looking into this. Apologies, as I confused two issues in my mind and therefore also in the question.</p>
<p>The first is individuals from w_indresp who do not match onto w_oslaua. I get 57, 10, 22, 27, 9, 16, 16, 20. So, 10 more than your team. For these 10, gor_dv is NOT missing. As it's only 10, though, I am not too worried about them.</p>
<p>The second issue is that when I then merge indresp_oslaua panel with the unemployment data using interview year and oslaua, I find that there are 46,234 unmatched observations from indresp_oslaua, and that 55% are in Northern Ireland. Upon reflection, because local authority is not missing, I now think this might have something to do with boundary changes, which might be beyond the scope of the UKHLS team. Unless there are any obvious pitfalls that jump out at you?</p>
<p>Thanks again.</p>
<p>Kind regards,<br />Clara</p> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52152020-07-22T09:18:49ZGundi Kniesgknies@essex.ac.uk
<ul><li><strong>% Done</strong> changed from <i>50</i> to <i>80</i></li></ul><p>Hi Clara,<br />jumping in here as I probably know a little more about geographical data linkage than Alita this being my area of research.</p>
<p>I think you are right - you probably have downloaded unemployment data that include different local authority area codes than the ones we provide with the data. The user guidance provided with the data download from the UKDS describes the source / version of the look-up files we use. To address the issue you'll have to find unemployment data that use the same geograhy or match the geography you have to the geography used in Understanding Society.</p>
<p>Hope this helps,<br />Gundi</p> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=52162020-07-22T09:28:14ZClara Mascaro
<ul></ul><p>Thanks Gundi, yes I will look into getting a better match with the look-up files.</p>
<p>Thank you all for your help.</p>
<p>Best wishes,<br />Clara</p> Understanding Society User Support - Support #1379: Unmatched individuals when linking UKHLS to local authority datahttps://iserredex.essex.ac.uk/support/issues/1379?journal_id=58882021-03-02T15:12:30ZUnderstanding 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>Clara Mascaro</i></del>)</li><li><strong>% Done</strong> changed from <i>80</i> to <i>100</i></li></ul>