The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Merge Service Availability data with individual data for zimbabwe (Merging )
Merge Service Availability data with individual data for zimbabwe [message #20437] Mon, 02 November 2020 06:44 Go to next message
anjalibansal6693 is currently offline  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"
Re: Merge Service Availability data with individual data for zimbabwe [message #20441 is a reply to message #20437] Mon, 02 November 2020 08:34 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2312
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.

Re: Merge Service Availability data with individual data for zimbabwe [message #20442 is a reply to message #20441] Mon, 02 November 2020 08:37 Go to previous messageGo to next message
anjalibansal6693 is currently offline  anjalibansal6693
Messages: 14
Registered: February 2018
Member
I am using the data files for cluster level information - ZWSQ02DT from Zimbabwe 1st DHS data set
Re: Merge Service Availability data with individual data for zimbabwe [message #20443 is a reply to message #20442] Mon, 02 November 2020 09:50 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2312
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


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


Current Time: Mon Jun 21 21:48:33 Coordinated Universal Time 2021