The DHS Program User Forum: General » Merging PR and IR with only ever-married women

Home » Topics » General » Merging PR and IR with only ever-married women

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

Re: Merging PR and IR with only ever-married women [message #29753 is a reply to message #29545]

Wed, 31 July 2024 04:15

albena
Messages: 12
Registered: February 2015

Member

Thank you very much for your help!

I wanted to share the code I use for adjusting the sampling weights for non-response of the ever-married women in the case when the IR data is based only on ever-married women. I merge the PR with the IR dataset to retrieve the never-married women and also construct the sampling weights for them .


use "dir.../BDPR7RFL.dta", clear // this is an example with the survey for Bangladesh 2017/18

* keep women age 15-49 years

keep if hv104 ==2
keep if hv105 >=15 & hv105 <=49

rename hv001 v001 
rename hv002 v002
rename hvidx v003

* merge with IR data
merge 1:1 v001 v002 v003 using "dir../BDIR7RFL.dta"

tab hv116 _m

egen hv005_sum=sum(hv005) if hv116~=0, by(hv023)
egen response=sum((_m==3)*hv005/hv005_sum) if hv116~=0, by(hv023)

* constructed weight for ever-married with adjustment for nonresponse
gen wt=hv005*(1/response) if _m==3


***
* Check re-scaled constructed weight equals v005
egen temp=mean(wt)
gen wt_rescaled=(wt/temp)*1000000

sum wt_rescaled v005
corr wt_rescaled v005
*** 


* weights for never-married
replace wt = hv005 if _m==1 & hv116==0

drop if wt ==.

Does this approach seem somewhat correct to you? I have a doubt about the condition hv116~=0. Is it more correct to have hv117==1 (include only the eligible women for the wm interview)? I also tried with hv116~=0 & hv103 ==1 (woman slept last night in the household). The hv102==1 (usual resident) doesn't play any role I think (?).

I think that my point refers very much to the definition of eligible women for the wm interview in the case of ever-married IR. Are the eligible women just hv116 ~=0 & hv103 ==1 & age >=15 & age <=49? Why can some ever-married women be non-eligible? Maybe this is because they turn out to be never married? Or is it because they are physically/mentally unable to do the IR interview, e.g. because mentally ill, in labor, ...? If women are non-eligible because they are actually never married, then I should indeed use the hv117 variable. If they are non-eligible because of incapacity to do an individual interview I should use the hv116 variable. So, I was wondering which women are included in the set hv116~=0 & hv117==0? Could you help me with this?

Thank you!

Report message to a moderator

[Message index]

		Merging PR and IR with only ever-married women By: albena on Mon, 01 July 2024 12:34
		Re: Merging PR and IR with only ever-married women By: Janet-DHS on Wed, 03 July 2024 15:27
		Re: Merging PR and IR with only ever-married women By: albena on Wed, 31 July 2024 04:15
		Re: Merging PR and IR with only ever-married women By: Janet-DHS on Wed, 31 July 2024 14:32

Previous Topic:	Cooking place classification explanation in HR file
Next Topic:	Clarification on v511 in IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 13 23:57:30 Coordinated Universal Time 2025