Hi Everyone
I am working on India Human Development Survey (IHDS). It is a cross sectional Data.
I have individual(which includes individual residing in the household), household and birth history file.
I am able to merger Household and individual perfectly. But, the birth history file contains the birth order of dead and live children along with their mother ID.
When I merge the already merged household and individual file with birth history file with mother's ID and household ID as identifiers, the result are not appropriate.
Can you Guys please suggest me how to do it ?
Thank YOu