A binary variable for children under the age of 7 in a given household
I hope you had a good holiday season. When you get the chance please help me with this one. I would like to define a binary variable equal to one if there is a child or more than one under the age of seven in a given household. My main data set consists of female characteristics and the characteristics of her husband or spouse. Essentially, I have only wives in my main dataset with their characteristics plus their spouses'.
I guess I must look at the w_child files to get the pidp of the child, the birthy of the child and the mnpid, which is the identification of the mother. Now the fun starts. How do I match or merge the information from the w_child files to my main file with wives' pidp only?
Once again I would highly appreciate your help.