Project

General

Profile

Support #960

pid and pidp not uniquely identifying rows

Added by Gabriele Dente almost 2 years ago. Updated over 1 year ago.

Status:
Resolved
Priority:
Normal
Category:
-
Target version:
Start date:
04/16/2018
Due date:
% Done:

100%

Estimated time:

Description

Greetings,

I'm trying to use the BHPS armonised files, and wanted to merge files in the same waves (I need to merge indresp, income and jobhist). The problem is that the pid and pidp variables, that are suppose to uniquely identify each individual, do not actually do it. What I mean is, each individual, identified through the pid or pidp variables, appears in multiple rows, so when I try to merge the files I get the error saying that "variable pidp(or pid) does not uniquely identify observations in the using data".
Any help on the matter would be really appreciated!

History

#1 Updated by Stephanie Auty almost 2 years ago

  • Status changed from New to In Progress
  • Assignee set to Stephanie Auty
  • Target version set to X M
  • % Done changed from 0 to 10
  • Private changed from Yes to No

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 Alita Nandi almost 2 years ago

  • Assignee changed from Stephanie Auty to Gabriele Dente
  • % Done changed from 10 to 90

Hello Gabriele,

The row in indresp is uniquely identified by pid/pidp but the rows in files income & jobhist are uniquely identified by pidp + other variables.
For bw_jobhist_bh it is pidp/pid PLUS bw_jspno_bh
For bw_income_bh it is pidp/pid PLUS bw_fiseq_bh

Hope this helps.

Best wishes,
Alita

#3 Updated by Gabriele Dente almost 2 years ago

That helps a lot.
Thank you so much for your help!

Best regards,
Gabriele

#4 Updated by Stephanie Auty over 1 year ago

  • Status changed from In Progress to Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF