derived variable for total number of children
I'd like to create variables for a total number of biological children for individuals in each wave. My understanding is that nnatch gives me the number of biological children currently residing in the household, and lnprnt is for the number of children outside hh in wave 1 and only applies to new entrants in later waves. What I want is a series of variables for the total number of children in each wave (no matter dead or alive, residing in the hh or living separately), i.e. something along these lines:
pidp a_nch b_nch c_nch d_nch e_nch
1 0 0 0 1 1 (a person has a new child between waves 3 and 4)
2 1 1 1 1 1 (a person enters the study with one child and doesn't have any more children)
Next I'd like to do the same for the total number of adoptive children.
Any advice on this would be much appreciated.