Support #155
closedNumber of biological children in the household (nnatch)
100%
Description
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: b.m.wilson@lse.ac.uk).
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).