The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » merging multiple years when adminitrative divisin have changed
merging multiple years when adminitrative divisin have changed [message #2148] Mon, 12 May 2014 09:27 Go to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Dear all,
i want to merge three years of DHS Rwanda. However, administrative divisions have changed b/w the first and the last surveys.
To have comparable statistics over years, i want to use the more recent administrative division and affect it to all surveys. I plan to retrieve from the last years the correspondence between cluster (hv001) and districts ( hv023 or shdistr) and then affect very cluster from the other year to the new districts base on the value of the cluster hv001.
is is correct?
To be correct, i need that hv001 always affect the same number to the same cluster ( ~village). Is it the case?
thanks in advance
Re: merging multiple years when adminitrative divisin have changed [message #2155 is a reply to message #2148] Mon, 12 May 2014 15:13 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
Following is a response from Senior Data Processing Specialist, Noureddine Abderrahim:

HV001 is internal to the survey, which means that HV001 in any survey does not necessarily correspond to the same HV001 in another survey, even within the same country.

You might want to consult the implementing agency for the common enumeration areas since they might be different between surveys. The implementing agency is mentioned in the final report of the survey, and reports can be downloaded from the website.
Re: merging multiple years when adminitrative divisin have changed [message #2158 is a reply to message #2155] Tue, 13 May 2014 04:45 Go to previous message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
thanks a lot , very useful to know that
Previous Topic: Bangladesh 2011 DHS: Merging "children" and "male" files
Next Topic: Merging data files in Stata
Goto Forum:
  


Current Time: Sat Mar 28 20:42:44 Eastern Daylight Time 2020