try to link the birthweight to each child
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
#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 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.
Stephanie Auty - Understanding Society User Support Office
#3 Updated by Alita Nandi over 1 year 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.