Wealth Index and place of residence [message #3746] |
Wed, 04 February 2015 11:19 ![Go to next message Go to previous message](/theme/default/images/down.png) |
mmacmull
Messages: 4 Registered: January 2015 Location: United States
|
Member |
|
|
Hi, I have been having some trouble to work with Uganda's 2011 data. FYI I am working with STATA.
I am only interested in some questions on the women's questionnaire (only for women that gave birth, since my outcome is birth assistance) and only two questions from the household questionnaire (HV271 and HV025). The individual recode ugir60dt file is too large to open it with STATA, I tried using the "Select" software but I get an error. I opened the file with SPSS to check the data.
My questions are:
1. Since I will be performing my analysis with STATA I used the births recode file (ugbr60dt) instead to get the variables I need for the women. All the variables I need are included in this dataset. Since I am only interested in those women that gave birth, is ok to use this dataset instead of the individual recode?
2. I need to merge HV271 and HV025 from the household recode to the previous dataset and match the women with this two household characteristics (I match using hhid). When I do so I get a lot of missing values. What calls my attention is that I have the data for households with low Household number (<24) but not for the rest. Is this ok? Why is this? I took a look at the Individual's recode on SPSS and saw that there are a lot of missing values too, but couldn't check if they are the same.
I need to know if I am doing the right thing.
Thanks a lot,
Mercedes
|
|
|