Support #874

try to link the birthweight to each child

Added by YIN XU almost 6 years ago. Updated over 5 years ago.

Start date:
% Done:



There is a file called a_natchild containing the information about the natural children including birth weight, gestational age, and breastfed.
There is another file called a_child containing information about child's identifier(pidp), childs age (a_dvage).
I had a hard time trying to link those two files together. a_natchild only provided a_childno, which is the birth order. But I don't know which kid that's apply for (e.g. pidp). Is the a_childno from a_natchild same as the a_childpno ? Do you have any suggestions about how to link the birthweight to each child? Many thanks

Files (7.04 KB) Alita Nandi, 01/08/2018 06:20 PM

Updated by Stephanie Auty almost 6 years ago

  • Status changed from New to In Progress
  • Assignee set to Stephanie Auty
  • Target version set to M1
  • % 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 Office


Updated by Stephanie Auty almost 6 years ago

  • Assignee changed from Stephanie Auty to Alita Nandi

Updated by Alita Nandi over 5 years ago

We sincerely apologise for the delay in responding to this issue. The delay was partly due to investigating this issue and finding appropriate solutions.

The file A_NATCHILD includes inforamtion about natural children as reported by their parents and so each row (in most cases) is at the parent-child level. The parent can be identified using A_HIDP and A_PNO and the child can be identified using A_HIDP A_LCHNO where A_LCHONO is the PNO of the child. So, ideally each row should be uniquely identified by A_HIDP A_PNO A_LCHNO. However, there are a few cases where there are duplicates. In the attached Stata syntax we check such cases and provide suggestions about tackling this issue for those interested in matching resident biological children in A_NATCHILD with valid birth information with their information in A_INDALL. The Syntax file includes comments which explains every step. If you have any questions or identify any problems please let me know.

Best wishes,


Updated by Alita Nandi over 5 years ago

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

Updated by Stephanie Auty over 5 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 90 to 100

Also available in: Atom PDF