The DHS Program User Forum: Child Health » merging HR and KR files and weighitng for analysis

Home » Topics » Child Health » merging HR and KR files and weighitng for analysis

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

Re: merging HR and KR files and weighitng for analysis [message #27018 is a reply to message #26998]

Mon, 12 June 2023 09:20

Janet-DHS
Messages: 937
Registered: April 2022

Senior Member

Following is a response from DHS staff member, Tom Pullum:

You are on the right track. Below I will post a modification of how you were doing the merge. You can save the temp file as you did--I just prefer to save it differently.

I recalculate age in single years at the time of the birth, using the cmc (century month code) for when the child was born minus the cmc for when the mother was born, dividing by 12, and converting an integer . v013 is age in five-year intervals and at the time of the survey, not the time of the birth. You can recode to intervals of age as you wish.

The sample weight variable to use is v005. This is the weight for the mother and it is used for her children. It is approximately proportional to hv005 but is adjusted for women's nonresponse.

The cases in the IR file are women. The cases in the KR file are children. The numbers of cases in the two files are different. The number of mothers is less than the number of women but more than the number of children. So the numbers you gave are ok.

Here are Stata lines that will do the merge. Let us know if you have other questions.

* specify a workspace
cd e:\DHS\DHS_data\scratch

use hv001 hv002 hv226 hv241 hv252 using "...RWHR81FL.DTA", clear

rename hv001 cluster
rename hv002 hh
sort cluster hh
save RWHRtemp.dta, replace

use "...RWKR81FL.DTA", clear
rename v001 cluster
rename v002 hh
gen mo_age_at_birth=int((b3-v011)/12)
sort cluster hh
merge m:1 cluster hh using RWHRtemp.dta
tab _merge

* _merge=2 for households with no children in the KR file
keep if _merge==3

Report message to a moderator

[Message index]

		merging HR and KR files and weighitng for analysis By: ashonci on Thu, 08 June 2023 02:49
		Re: merging HR and KR files and weighitng for analysis By: Janet-DHS on Mon, 12 June 2023 09:20
		Re: merging HR and KR files and weighitng for analysis By: ashonci on Wed, 14 June 2023 02:42
		Re: merging HR and KR files and weighitng for analysis By: Janet-DHS on Tue, 20 June 2023 11:25
		Re: merging HR and KR files and weighitng for analysis By: ashonci on Mon, 26 June 2023 02:43
		Re: merging HR and KR files and weighitng for analysis By: Janet-DHS on Mon, 03 July 2023 10:40

Previous Topic:	Maternal Mortality
Next Topic:	Geospatial analysis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 9 14:10:33 Coordinated Universal Time 2025