Understanding Society User Support

Hi yes, sorry I meant pidp, it doesn't match with any pidp. I can't seem to find the pid variable in any of the BHPS files to test if that matches.

Dear Esme,

Sorry, pid and not pidp is the variable to use. The label for rapid_bh "X-wave person identifier of resp. adult" is ambiguous, it should clarify that the X-wave person identifier is pid. I will pass on this information to the data team. The variable pid is in every BHPS indall file and so, you should be able to match the children to their responsible adult using pid. I have checked this using pid and was able to match approx 3000-4000 children with the responsible adult at each BHPS wave. Here is the Stata syntax I used to check this.
The global "dt" refers to the location of the downloaded data.

foreach w in a b c d e f g h i j k l m n o p q r {
qui {
use pid b`w'_rapid_bh using "$dt/bhps/b`w'_indall", clear
fre b`w'_rapid_bh
keep if b`w'_rapid_bh>0
}
di "`w'"
cou
d b`w'_rapid_bh
qui {
rename pid kpid
rename b`w'_rapid_bh pid
save temp, replace
use pid b`w'_age using "$dt/bhps/b`w'_indall", clear
merge 1:m pid using temp
}
di "`w'"
cou if _m==3 // number of children's rapid_bh matches with pid of household members in indall
su b`w'_age if _m==3 // to check the age of the responsible adult
}

Best wishes,
Understanding Society User Support Team