Re: Merging KR with PR for Malawi 2015-16 [message #17482 is a reply to message #17440] |
Thu, 28 March 2019 11:41 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Bridgette-DHS
Messages: 3139 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
Why are you doing this merge? The variables you need are already in the KR file, and you do not need to merge with the PR file to get them. The variables hc70, hc71, and hc72 in the PR file are the same as hw70, hw71, and hw72 in the KR file (or the BR file).
Table 11.1 on page 170 of the main report for this survey gives the % stunted as 37.1%, based on 5707 children. This number comes directly from the PR file, using weights hv005 and restricting to de facto residence (hv103=1).
After you open the PR file, enter these lines:
gen stunted=0
replace stunted=1 if hc70<-200
replace stunted=. if hc70<-600 | hc70>600
tab stunted if hv103==1 [iweight=hv005/1000000]
You will get 37.13% stunted, with 5706.83 weighted cases. That is, you match the report this way.
The KR file includes the children of women who are de facto members of the household. I don't know why you have a difference between 6033 and 6053 because I don't know where the 6033 and 6053 themselves come from.
|
|
|