Project

General

Profile

Support #1508

Which is the best way to merge all the files (INDRESP, HHRESP,JOBHIST, YOUNTH) across the 18 BHPS waves

Added by Mario Martinez-Jimenez 10 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
Urgent
Assignee:
-
Category:
-
Start date:
02/09/2021
% Done:

100%


Description

Dear Sir or Madam,

I have appended all the 18 waves of each file (e.g. indresp, hhresp, indall, jobhist, younth), and now, I would like to merged between them. Therefore, my question is which will be the best commenad to merged them without losing observations if then we would like to apply panel data methods?

Thank you so much for your time.

BEst wishes,

Mario

#1

Updated by Understanding Society User Support Team 10 months ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 80

Hello Mario,

To merge INDRESP and HHRESP use HIDP

To merge INDRESP and YOUTH - there is no point doing this as those who are in INDRESP are not in YOUTH

TO merge JOBHIST and INDRESP use PIDP. But note that JOBHIST is a multilevel file where for each person (identified by PIDP) there are as many rows as jobs each identified by JSPNO. So, each row is identified by PIDP br_JSPNO. You need to first decide what you want to do with the information in JOBHIST before simply merging with INDRESP.

Best wishes,
Understanding Society User Support

#2

Updated by Understanding Society User Support Team 10 months ago

  • Private changed from Yes to No
#3

Updated by Understanding Society User Support Team 10 months ago

  • Assignee changed from Understanding Society User Support Team to Alita Nandi
#4

Updated by Understanding Society User Support Team 4 months ago

  • Assignee deleted (Alita Nandi)
#5

Updated by Understanding Society User Support Team about 2 months ago

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

Also available in: Atom PDF