Project

General

Profile

Support #1388

Merging geographical special license data

Added by James Risk over 3 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
High
Assignee:
-
Category:
-
Start date:
07/29/2020
% Done:

100%

Description

Hi,

I've merged two geographical special license datasets (SN7630 and SN7248) with the main dataset (SN6614) for each wave 1-9 using the variable hidp, but there appears to be more observations (hidps) in the special license datasets than the main dataset. Approximately 77% of observations across waves 1-9 are matched, 23% in special licence and not matched, and <1% in the main dataset and not matched.
I presume there's either an error in my code or a valid reason for this? Any help would be appreciated.

Many Thanks,
James

#1

Updated by Alita Nandi over 3 years ago

  • Status changed from New to Feedback
  • Assignee set to James Risk
  • % Done changed from 0 to 50
  • Private changed from Yes to No

Hello,

The geographical special license data files include households with valid postcodes including those that did not respond.
So, if you merge these geography files with w_hhsamp (households issued including non-responding households) then these would match except for the households in w_hhsamp without valid postcodes. But if you merge these geography files with w_hhresp, w_indall, w_indresp which include responding households only, then there will be households in the geography files that will not appear in these files.

Does this answer your question?

Best wishes,
Alita

#2

Updated by James Risk over 3 years ago

Hi Alita,

It does, thanks for your help!

Kindest,
James

#3

Updated by Alita Nandi over 3 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 50 to 100
#4

Updated by Understanding Society User Support Team over 2 years ago

  • Assignee deleted (James Risk)

Also available in: Atom PDF