The DHS Program User Forum: General Data Questions » Is HW included in KR and IR/MR included in PR?

Home » Data » General Data Questions » Is HW included in KR and IR/MR included in PR?

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Is HW included in KR and IR/MR included in PR? [message #14965 is a reply to message #14964]

Tue, 22 May 2018 10:01

Bridgette-DHS
Messages: 3061
Registered: February 2013

Senior Member

Following is another response from Senior DHS Stata Specialist, Tom Pullum:

The anthropometry and hemoglobin variables are included in the IR, MR, and KR files, as well as the PR file. You do not need to do a merge to get those variables.

The files are defined by the units or cases that they include, not by the variables they include. The variables are specific to the cases and to whether they come from the household survey or the individual surveys of men and women. The children's data come mainly from the interview with the mother. The data structure is not simple, but it is simpler than you seem to think it is.

Below I will paste Stata lines to do what you say you want to do. You should insert lines for each file to save just the variables you need. Otherwise you will end up with an unmanageable number of variables and some duplicates, especially from the IR and KR variables. You will have to set the paths.

* Prepare IR file for merge
use IR.dta, clear 
gen in_IR=1
rename v001 hv001
rename v002 hv002
rename v003 hvidx
sort hv001 hv002 hvidx
save IRtemp.dta, replace

* Prepare MR file for merge
use MR.dta, clear 
gen in_MR=1
rename mv001 hv001
rename mv002 hv002
rename mv003 hvidx
sort hv001 hv002 hvidx
save MRtemp.dta, replace

* Prepare KR file for merge
use KR.dta, clear 
gen in_KR=1
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv001 hv002 hvidx
save KRtemp.dta, replace

* Prepare PR file for merge
use PR.dta, clear 
gen in_PR=1
sort hv001 hv002 hvidx

* Merge PR with IR
merge hv001 hv002 hvidx using IRtemp.dta
rename _merge _merge_PR_IR
sort hv001 hv002 hvidx

* Merge with MR
merge hv001 hv002 hvidx using MRtemp.dta
rename _merge _merge_PR_MR
sort hv001 hv002 hvidx

* Merge with KR
merge hv001 hv002 hvidx using KRtemp.dta
rename _merge _merge_PR_KR

Report message to a moderator

[Message index]

		Is HW included in KR and IR/MR included in PR? By: nibiti on Wed, 09 May 2018 09:01
		Re: Is HW included in KR and IR/MR included in PR? By: Bridgette-DHS on Mon, 21 May 2018 08:50
		Re: Is HW included in KR and IR/MR included in PR? By: nibiti on Tue, 22 May 2018 08:23
		Re: Is HW included in KR and IR/MR included in PR? By: Bridgette-DHS on Tue, 22 May 2018 08:38
		Re: Is HW included in KR and IR/MR included in PR? By: Bridgette-DHS on Tue, 22 May 2018 08:53
		Re: Is HW included in KR and IR/MR included in PR? By: nibiti on Tue, 22 May 2018 09:24
		Re: Is HW included in KR and IR/MR included in PR? By: Bridgette-DHS on Tue, 22 May 2018 10:01
		Re: Is HW included in KR and IR/MR included in PR? By: nibiti on Tue, 22 May 2018 10:31
		Re: Is HW included in KR and IR/MR included in PR? By: Bridgette-DHS on Wed, 23 May 2018 07:52
		Re: Is HW included in KR and IR/MR included in PR? By: Hassen on Fri, 25 May 2018 00:33

Previous Topic:	Is there a Recode Manual for KR, PR and HW datasets?
Next Topic:	Recode Manual for DHS-VII

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat May 18 07:08:11 Coordinated Universal Time 2024