The DHS Program User Forum: Merging data files » merging multiple years when adminitrative divisin have changed

Home » Data » Merging data files » merging multiple years when adminitrative divisin have changed

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

merging multiple years when adminitrative divisin have changed [message #2148]

Mon, 12 May 2014 09:27

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

Report message to a moderator

Re: merging multiple years when adminitrative divisin have changed [message #2155 is a reply to message #2148]

Mon, 12 May 2014 15:13

Bridgette-DHS
Messages: 3034
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.

Report message to a moderator

Re: merging multiple years when adminitrative divisin have changed [message #2158 is a reply to message #2155]

Tue, 13 May 2014 04:45

anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy

Member

thanks a lot , very useful to know that

Report message to a moderator

Previous Topic:	Bangladesh 2011 DHS: Merging "children" and "male" files
Next Topic:	Merging data files in Stata

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 18 16:25:30 Coordinated Universal Time 2024