The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » DRC 2007
DRC 2007 [message #8782] Thu, 17 December 2015 10:25 Go to next message
cbdolan is currently offline  cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
Member
In the 2007 DRC DHS the variable v024 (province) is coded (20,30,40,50,61,62,63,70,80,90). In the hard copy of the survey there is a field for province to be entered, but not the name/value association. In order to figure out which numerical value matched the province name I did the following:

tab v024 ADM1_NAME if v007==2007

I included v007==2007, because I also have the 2013/14 DRC DHS in my data which was labeled.

This code works to figure out the name of 10 of the provinces, but there is conflicting information. One province was not assigned a numerical value. Instead it was assigned the character name of the province 'orientale' when running the crosstab between province and ADM1_NAME 'orientale' is assigned to 'Kinshasa' which is a city-province across the country from the province 'orientale'.

Can you please explain to me what the value 'orientale' in v024 represents in the 2007 DRC DHS? Please see attached screenshot.

Thanks
  • Attachment: 1.png
    (Size: 238.87KB, Downloaded 422 times)
Re: DRC 2007 [message #8783 is a reply to message #8782] Thu, 17 December 2015 10:42 Go to previous messageGo to next message
cbdolan is currently offline  cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
Member
I have a similar follow up question related to the 2013/14 DRC DHS.

See attached image. In the 2013/14 DHS I did the following to figure out the value/name association:

tab v024 ADM1_NAME, nolabel

Province '10' has both 'Kinshasa' and 'Orientale' assigned as the ADM1_CODE.

Thanks
  • Attachment: 2.png
    (Size: 254.60KB, Downloaded 414 times)
Re: DRC 2007 [message #8900 is a reply to message #8783] Tue, 12 January 2016 12:20 Go to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
I think I'm missing something here. The codes are in the dataset. If you just do the following with the 2007 data you get the coding:

. lab list v024
v024:
10 kinshasa
20 bas-congo
30 bandundu
40 equateur
50 orientale
61 nord-kivu
62 maniema
63 sud-kivu
70 katanga
80 kasai oriental
90 kasai occident

For 2013/14 the coding is as follows:
. lab list v024
v024:
1 kinshasa
2 bandundu
3 bas-congo
4 equateur
5 kasai-occidental
6 kasai-oriental
7 katanga
8 maniema
9 nord-kivu
10 orientale
11 sud-kivu

Previous Topic: Peru 2004 and 2007
Next Topic: Turkey mother tongue variable
Goto Forum:
  


Current Time: Thu Mar 28 18:44:34 Coordinated Universal Time 2024