Understanding Society User Support

Hello,

The file ca_indresp_w is the adult level file where pidp uniquely identifies each row. The information provided by parents/guardians about their children is put into a child level file, ca_schild_w. For further details see Section 11.

In the file cs_schild_w pidp_c uniquely identifies each row. So, if you rename pidp_c to pidp and match it to xwavedat in the main survey (released version which includes data from waves1-9), then you will see that you can match all but 310 children to the main survey data.

In ca_schild_w, the pidp of the person who provided information about the child (pidp_c) is given by pidp_m (if female) and pidp_f (if male). So, if you create a variable, pidp which equals pidp_f or pidp_m (whichever is not -8), and then match to ca_indresp_w using pidp then you will see that all cases in ca_schild_w will match to ca_indresp_w.

If you use Stata, then take a look at this syntax which explains what I have said:
(1)
use ca_schild_w, clear
isid pidp_c
rename pidp_c pidp
merge 1:1 pidp using xwavedat

(2)
use ca_schild_w, clear
generat long pidp=pidp_m
replace pidp=pidp_f if pidp==-8
merge m:1 pidp using ca_indresp_w

Does this answer your question? If not, please let me know.

Best wishes,
Alita