The DHS Program User Forum: General » Merge Service Availability data with individual data for zimbabwe

Home » Topics » General » Merge Service Availability data with individual data for zimbabwe (Merging )

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

Merge Service Availability data with individual data for zimbabwe [message #20437]

Mon, 02 November 2020 06:44

anjalibansal6693
Messages: 14
Registered: February 2018

Member

Dear Sir/Mam

I was trying to replicate some paper based on DHS-1 Data set so that to make sure if I am getting accurate results, so for that I used the DHS-1 data set of Zimbabwe and I was trying to merge the Service availability cluster level information with the individual level, but I did not able to produce exact results. It would be very helpful if anyone can help with that.

//syntax: using the individual level data and
// merge m:1 "cluster number" using the " Service availability data of Zimbabwe"

Report message to a moderator

Re: Merge Service Availability data with individual data for zimbabwe [message #20441 is a reply to message #20437]

Mon, 02 November 2020 08:34

Bridgette-DHS
Messages: 2270
Registered: February 2013

Senior Member

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

Are you using data files that are available on the DHS website? Please give the file name for the cluster level information.

Report message to a moderator

Re: Merge Service Availability data with individual data for zimbabwe [message #20442 is a reply to message #20441]

Mon, 02 November 2020 08:37

anjalibansal6693
Messages: 14
Registered: February 2018

Member

I am using the data files for cluster level information - ZWSQ02DT from Zimbabwe 1st DHS data set

Report message to a moderator

Re: Merge Service Availability data with individual data for zimbabwe [message #20443 is a reply to message #20442]

Mon, 02 November 2020 09:50

Bridgette-DHS
Messages: 2270
Registered: February 2013

Senior Member

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

I will paste below the lines to do a merge with the IR file (without the paths to the files). If your question is about matching the results in a paper, we cannot help with that. But was this a DHS report?

use ZWSQ02FL.DTA , clear

rename acluster v001
sort v001
save ZWSQ02temp.DTA, replace

use ZWPR01FL.DTA , clear
sort v001
merge v001 using ZWSQ02temp.DTA
tab _merge
keep if _merge==3
drop _merge

Report message to a moderator

Previous Topic:	Aggregating up to district level in NFHS-4
Next Topic:	DHS STATcompiler vs DHS household data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed May 12 06:53:59 Coordinated Universal Time 2021