The DHS Program User Forum: General » MERGING IR AND HR FILE

Home » Topics » General » MERGING IR AND HR FILE ((Problem with STATA compilation))

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

Re: MERGING IR AND HR FILE [message #29095 is a reply to message #29066]

Tue, 23 April 2024 13:52

Janet-DHS
Messages: 938
Registered: April 2022

Senior Member

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

Here is a Stata program to merge the PR and IR files. It differs only slightly from the one to merge the HR and PR files.

* Specify a workspace
cd e:\DHS\DHS_data\scratch
* Prepare the PR file; keep only the household-level variables
use "...IAPR7EFL.DTA", clear
* Reduce to eligible women
keep if hv117==1
gen cluster=hv001
gen hh=hv002
gen line=hvidx
save PRtemp.dta, replace
 use "...IAIR7EFL.DTA", clear
gen cluster=v001
gen hh=v002
gen line=v003
merge 1:1 cluster hh line using PRtemp.dta
* Some women were eligible but were not interviewed (nonresponse cases); drop them
tab _merge
keep if _merge==3
drop _merge

Report message to a moderator

[Message index]

		MERGING IR AND HR FILE By: Noyel Sebastian on Wed, 03 April 2024 12:31
		Re: MERGING IR AND HR FILE By: Janet-DHS on Wed, 10 April 2024 09:02
		Re: MERGING IR AND HR FILE By: Noyel Sebastian on Fri, 19 April 2024 00:47
		Re: MERGING IR AND HR FILE By: Janet-DHS on Tue, 23 April 2024 13:52

Previous Topic:	Regional variable v024
Next Topic:	Agricultural Land ownership: Treatment of Zero values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Feb 18 16:12:32 Coordinated Universal Time 2025