Support #155

Number of biological children in the household (nnatch)

Added by Ben Wilson over 9 years ago. Updated about 9 years ago.

Data analysis
Start date:
% Done:



Hi there, apologies if this is a known issue (I did search the FAQ & all open and closed issues), but I think I have found an issue with the variable a_nnatch for about 350 cases. I may be wrong, but it seems that this variable does not correctly calculate the total number of resident biological children for some household members. If this is a new issue, then I guess it is probably best for me to send syntax to explain and/or so you can replicate (I can't attach anything to this web form). Of course, please let me know if you want this (email: ).

To give a little more info of what I did to discover this, a brief summary is: In order to obtain ages of all resident biological children, I did some matching, separately by sex (of parents), using a combination of the various id variables to match all resident biological children (taken from indall and isolated using mnpno/fnpno) to all parents (taken from indall and using their pidp to match to the mpid/fpid of resident biological children). I then derive my own version of nnatch by counting non-missing values of the ages of resident biological children. My final dataset includes all household members (from indall) and I can see that nnatch is miscounting biological children (assuming that the mnpno/fnpno/mpid/fpid variables are correct).

Also available in: Atom PDF