Re: Merging KR with PR for Malawi 2015-16 [message #17437 is a reply to message #14997] |
Mon, 18 March 2019 08:26 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
Felixo
Messages: 1 Registered: March 2019
|
Member |
|
|
Dear Expert,
I am working on children malnutrition using Mdhs dataset.
I have been able to merge KR with PR files using PR file as the base file.
This is achieved by
1. convert variables v001, v002 and B16 to HV001, HV002 and HVIDX respectively, in the KR file.
2. sort cases using the key identifier variables HV001, HV002 and HVIDX
3. open the PR file and sort by HV001, HV002 and HVIDX
4. select cases based on HVIDX>=2 & HVIDX<=17 & HV103=1 & 0<=HC1<=59
5. Compute weight variable using HV005/1000000; and weigh the reduced dataset PR
With the above, I could obtain the prevalence of the stunting (37.1%), wasting (2.7%) and underweight (11.5%) as it were in the Malawi DHS report.
However, the sample size increases by 20 (from 6,033 to 6,053). Please advise appropriately on what I could do next to avoid this increase.
Thank you for your prompt intervention.
|
|
|