Project

General

Profile

Support #515

Matching pid across waves

Added by Christopher Booth over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Immediate
Category:
Data documentation
Target version:
-
Start date:
03/02/2016
Due date:
% Done:

100%

Estimated time:

Description

I have merged whhresp and windresp files using a m:1 match as you mentioned before. However, when matching pid between waves J and O I have found that only 1500 individuals are included in both waves. I am under the impression that this should not be the case as all individuals in the sample are followed for every wave? So should all individuals interviewed in wave J also have been interviewed in wave O? Please could you let me know if this is the case and possibly what could have led me to only finding 1500 persons with the same pids across waves J and O.

Thank you

History

#1 Updated by Alita Nandi over 4 years ago

  • Assignee changed from Gundi Knies to Christopher Booth
  • % Done changed from 0 to 90

Hello Christopher,

I have just replicated what you have done and I found 10,514 individuals in both waves J and O. Here is the code I used:

use oindresp, clear
merge m:1 ohid using ohhresp
drop if _m==2
drop _m
save o, replace

use jindresp, clear
merge m:1 jhid using jhhresp
drop if _m==2
drop _m
save j, replace

use o, clear
merge 1:1 pid using j

Best wishes,
Alita

#2 Updated by Victoria Nolan over 4 years ago

  • Status changed from New to Closed
  • % Done changed from 90 to 100

Also available in: Atom PDF