Compliments of the moment,
I am working on a project on women's poverty. The variables I need are spread across three datasets, i.e., household, household members, and women datasets. Most variables are coming from the household data sets with few from household members and women datasets. I want to align the women and household members to their individual household characteristics and eventually have one woman representing one household instead of multiple women per household.
Now the issues are:
1. In what order will it be appropriate to merge the files into one
2: Is it possible to identify the respondents in the women data set such that I can drop any other woman in the household such that when I merge I have only one woman to a household per cluster.
Thanks.
I am working on a project on women's poverty. The variables I need are spread across three datasets, i.e., household, household members, and women datasets. Most variables are coming from the household data sets with few from household members and women datasets. I want to align the women and household members to their individual household characteristics and eventually have one woman representing one household instead of multiple women per household.
Now the issues are:
1. In what order will it be appropriate to merge the files into one
2: Is it possible to identify the respondents in the women data set such that I can drop any other woman in the household such that when I merge I have only one woman to a household per cluster.
Thanks.
