The DHS Program User Forum: India » Merging BR and PR data

Home » Countries » India » Merging BR and PR data (Unmatched Observations)

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

Re: Merging BR and PR data [message #24786 is a reply to message #24766]

Mon, 11 July 2022 10:13

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

My apologies for a typo in my previous response. I should not have said v025, which is place of residence (1=urban, 2=rural). State is given by v024. The following merge will work. You need to remove from the BR file the cases with b16=0 or ".", which identify children who have died or left the household. The cases you want are those with _merge=3. You will want to include variables other than those I have included.

use v0* b* using "...IABR7AFL.DTA", clear
drop if b16==0 | b16==.
rename v024 state
rename v001 cluster
rename v002 hh
rename b16 line
sort state cluster hh line
save ...IABRtemp.dta, replace

use hv0* hvidx using "...IAPR7AFL.DTA", clear
rename hv024 state
rename hv001 cluster
rename hv002 hh
rename hvidx line
sort state cluster hh line

merge state cluster hh line using e:\DHS\DHS_data\scratch\IABRtemp.dta
tab _merge
keep if _merge==3

Report message to a moderator

[Message index]

		Merging BR and PR data By: hvs0013 on Wed, 29 June 2022 06:14
		Re: Merging BR and PR data By: Janet-DHS on Wed, 06 July 2022 09:33
		Re: Merging BR and PR data By: hvs0013 on Thu, 07 July 2022 04:16
		Re: Merging BR and PR data By: Janet-DHS on Mon, 11 July 2022 10:13
		Re: Merging BR and PR data By: hvs0013 on Thu, 14 July 2022 01:54
		Re: Merging BR and PR data By: Janet-DHS on Fri, 15 July 2022 08:49
		Re: Merging BR and PR data By: hvs0013 on Mon, 18 July 2022 02:46
		Re: Merging BR and PR data By: Janet-DHS on Wed, 20 July 2022 16:34
		Re: Merging BR and PR data By: hvs0013 on Sat, 23 July 2022 04:33

Previous Topic:	Treamtment of disputed areas
Next Topic:	Where can I find the data for Sibling composition in India

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 03:13:17 Coordinated Universal Time 2024