Project

General

Profile

Support #978

different size in "merge" and "previously been interviewed"

Added by Eduwin Pakpahan over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Normal
Category:
Survey design
Start date:
05/30/2018
% Done:

100%


Description

Dear all,
I am a new user of understanding society, so pls apologize if my question is quite basic.
I am trying to merge the wave1 and wave2 data, i.e. merging "b_indresp.dta" and "a_indresp.dta". Using merge function in stata (the stata code is 'merge 1:1 pidp using ... '), I found 38388 participants were both in wave1 and 2, 162019 were new entrants in wave 2 and 12606 were in wave 1 only. Then I look at those who have been interviewed before, by 'tab b_ff_ivlolw', I found 46164 individual had previously been interviewed. This is bigger than 38388 I obtained beforehand.

Do I miss something here or misunderstood with the b_ff_ivlolw?

#1

Updated by Stephanie Auty over 2 years ago

  • Category set to Survey design
  • Status changed from New to In Progress
  • Assignee set to Stephanie Auty
  • % Done changed from 0 to 10

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer

#2

Updated by Stephanie Auty over 2 years ago

  • Private changed from Yes to No
#3

Updated by Stephanie Auty over 2 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Stephanie Auty to Eduwin Pakpahan
  • Target version set to M2
  • % Done changed from 10 to 70

Dear Eduwin,

Looking at the variable b_hhorig will help you to answer this question. This is the sample origin. If you look at this variable for those who have b_ff_ivlolw==1 (they have had a previous individual interview) but are not in a_indresp, you will see that almost all of these are BHPS sample members, so their previous interview was during BHPS data collection, rather than Wave 1 of Understanding Society.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer

#4

Updated by Eduwin Pakpahan over 2 years ago

Thanks a lot, Stephanie.
I understand now the "previous wave".

Rgds,
Eduwin

#5

Updated by Stephanie Auty over 2 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 70 to 100

Also available in: Atom PDF