The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Rwanda PR recode h023 h024 districtt and region variables
Rwanda PR recode h023 h024 districtt and region variables [message #2133] Wed, 07 May 2014 05:55 Go to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Dear forum members,
Could you help me identifying provinces (new), regions, district and village variables in the PR recode files 2010, 2007-2008, 2005. I am realy struggling to find it. My purpose it to make various statistics at district levels and study their evolutions over time. Many thanks in advance
ac
Re: Rwanda PR recode h023 h024 districtt and region variables [message #2137 is a reply to message #2133] Wed, 07 May 2014 15:25 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Response from Lady Ortiz, Senior Data Processing Specialist:

Dear user,

You should check variables names that start with the letter "S" (these are "Country Specific"). In the case of Rwanda 2010, the district variable name is SHDISTR.

Thanks

Re: Rwanda PR recode h023 h024 district and region variables [message #2140 is a reply to message #2137] Thu, 08 May 2014 10:40 Go to previous messageGo to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Thanks a lot for your response .

However , it does not resolve my issues. I would like to compare mean values of a given variable Y over time 2005, 2007-2008, 2010 by district. However, districts values contained in shdist are not the same in 2005 (11 districts), 2007-2008 (10 districts) and 2010 (30 districts).
If take the current 30 districts as my reference geographic unit, on which basis could I affect enumeration area of the 2007-08 and 2005 survey in these 30 districts ?
Many thanks in advance
ac
Re: Rwanda PR recode h023 h024 districtt and region variables [message #2146 is a reply to message #2137] Mon, 12 May 2014 09:09 Go to previous messageGo to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Dear Bridgette , thank you so much for your response.
Where do i find the dictionnary for the country specific variables ?
thanks in advance
ac
Re: Rwanda PR recode h023 h024 districtt and region variables [message #2152 is a reply to message #2146] Mon, 12 May 2014 14:08 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
They are all in the same dictionary -- open the .map file in any text editor to search for variables.

For country specific questions, the variables are generally named and coded in the same way as they were on the questionnaire. The variable will have a leading "SH" if the question was asked at the household level, a leading "S" if asked at the women's level, and a leading "SM" if asked at the men's level.

Thanks
Re: Rwanda PR recode h023 h024 district and region variables [message #2156 is a reply to message #2140] Mon, 12 May 2014 15:17 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from our Senior Sampling Specialist, Ruilin Ren:

The Rwanda DHS 2005 used 12 provinces, and HV024 has 12 values. There were no districts specified in the 2005 Rwanda DHS. The 2007-2008 Rwanda Interim DHS used the county's new structure with 5 provinces (Rwanda changed the country structure after the 2005 DHS), no districts were specified. The 2010 DHS used the country's new structure with 5 provinces and 30 districts, the variable SHDIST identifies the 30 districts.

One can match the new provinces and districts with the old 12 provinces, but not in the other direction. You cannot split the 2005 DHS data or the 2007-2008 data into 30 districts because there is no identifier in the data file.
Re: Rwanda PR recode h023 h024 district and region variables [message #2157 is a reply to message #2156] Tue, 13 May 2014 04:44 Go to previous messageGo to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Dear Ruilin Ren , Thank you very much for your answer
to follow on waht you say "One can match the new provinces and districts with the old 12 provinces, but not in the other direction". I can find the correspondence between old and new provinces except for Kigali rural that is split between eastern and northern new provinces.
How do i know which part of kigali rural goes to eastern and which part of kigali rual goes to northern?
thanks in advance
ac
Re: Rwanda PR recode h023 h024 district and region variables [message #2159 is a reply to message #2157] Tue, 13 May 2014 09:05 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Response from Ruilin Ren:

The question is not clear enough for me to provide a precise answer. I assume that you don't know how to split the old province "Kigali Ngali" (the Kigali rural) into North and East provinces for the 2005 DHS data. There are two variables in the data file: HV024 defines the old 12 provinces, and SH90 defines the 5 new provinces, so you can solve the problem by using these two variables.
Re: Rwanda PR recode h023 h024 district and region variables [message #2160 is a reply to message #2159] Wed, 14 May 2014 05:31 Go to previous messageGo to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
thanks !
Re: Rwanda PR recode h023 h024 district and region variables [message #2545 is a reply to message #2159] Thu, 10 July 2014 07:48 Go to previous messageGo to next message
anneclaireclaire is currently offline  anneclaireclaire
Messages: 11
Registered: May 2014
Location: Italy
Member
Dear Ruilin Ren,
i am sorry but cannot find the sh90 in any year in the PR recode file . Could you also help me on that?
Re: Rwanda PR recode h023 h024 district and region variables [message #2550 is a reply to message #2545] Thu, 10 July 2014 18:22 Go to previous messageGo to next message
user-rhs is currently offline  user-rhs
Messages: 132
Registered: December 2013
Senior Member
Try the individual or HH recode file
Re: Rwanda PR recode h023 h024 district and region variables [message #2556 is a reply to message #2545] Fri, 11 July 2014 08:08 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
The variable SH90 was renamed to SHREGNAT in the latest version of the dataset. Please look for: SHREGNAT: Natural region. Sorry for the inconvenience.

Thanks,

Bridgette
Previous Topic: Rwanda DHS 2010: Discrepancy in result of Hb measurements
Next Topic: Burkina Faso weights?
Goto Forum:
  


Current Time: Wed Nov 27 17:18:08 Coordinated Universal Time 2024