Support #874: try to link the birthweight to each child - Understanding Society User Support

Actions

Copy link

Support #874

closed

try to link the birthweight to each child

Added by YIN XU about 7 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Urgent

Assignee:

Alita Nandi

Category:

Start date:

11/02/2017

% Done:

100%

Description

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

Linking_a_natchild_indall.do (7.04 KB) Linking_a_natchild_indall.do

Alita Nandi, 01/08/2018 06:20 PM

Actions

Copy link

Updated by Stephanie Auty about 7 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

Actions

Copy link

Updated by Stephanie Auty almost 7 years ago

Assignee changed from Stephanie Auty to Alita Nandi

Actions

Copy link

Updated by Alita Nandi almost 7 years ago

File Linking_a_natchild_indall.do Linking_a_natchild_indall.do added
% Done changed from 10 to 80

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,
Alita

Actions

Copy link