Project

General

Profile

Support #1011

merging main dataset (6933) with local authority districts (6666) using for both data sets all waves a-g

Added by Nico Ochmann over 4 years ago. Updated over 4 years ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Data analysis
Start date:
07/26/2018
% Done:

100%


Description

Hello Alita,

hope you are fine. I do have a question with regard to merging the above files. It is my understanding that in the districts (6666) data set I have household number and the variable for district in each wave file (in addition I generate the wave variable for a through g). I am not sure how to proceed. Do I produce and append all seven waves for the district data set first and then merge it with the main data set or do I merge each district data set (of each wave) individually with my main data set? If I appended all seven waves of the district data set first, I would suggest doing the following:

merge m:1 hidp wave using districts_appended_a-g

Now the thing that is not clear to me is that if I have two people with two different pidp's living in the same household (hence sharing the same hidp) in a given wave, how can they be uniquely identified in the using data set?

Once again, I would highly appreciate your suggestions.

Best wishes.

Nico

Also available in: Atom PDF