| Merging Women and Household Member Recode files [message #1322] |
Fri, 14 February 2014 07:49  |
nashallan
Messages: 7
Registered: February 2014
Location: Netherlands
|
Member |
|
|
Hello
I am analysing the association between household assets, maternal characteristics and child nutrition using Uganda 2011 DHS. I have also realized that in order to replicate the stunting rates reported in the DHS report, I should use the HC70 in the PR files (household member). Hence I am using this as my base file. I have two questions:
1. First I rename v001 hv001, v002 hv002 and v003 hvidx
After sorting hvidx hv001 hv002, I then open the PR file (my base) so that I can merge using the IR (women's file). I use the following code
merge 1:1 hvidx hv001 hv002 using "C:\Users\ddg\Documents\UGIR60FL.DTA".
Is this correct? Should I merge 1:1 or m:1 or 1:m?
2. When using the PR file, I would like to conduct some of my analysis at household level e.g. descriptive stats of household assests. In the HR file, it is clear there are 9033 households, but in the PR file because of its structure there are more than 44000 individual observations. Can I use HVIDX==1 as the household level since it denotes the household head line number? for instance svy:tab hv244 if hvidx==1 would give me the same result as that in the DHS report.
Kindly assist
Nashallan
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
