Home » Countries » Nigeria » Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013
| Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013 [message #2962] |
Wed, 24 September 2014 09:20  |
austin
Messages: 1
Registered: September 2014
|
Member |
|
|
Hello!
I am a bit confused about how the states (variable SState) were coded for the 2003, 2008 and 2013 Nigerian data series for the Northern Nigerian States in the women's file.
1. From my understanding there are 20 Northern Nigerian States, and Rivers is not one of them.
2. For 2003 they are coded by State name, but for 2008 and 2013 some are coded by name, but mainly they are coded by number-
a. How to I know which state each number corresponds to?
Thank you!
|
|
|
|
| Re: Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013 [message #2973 is a reply to message #2962] |
Thu, 25 September 2014 11:09  |
Liz-DHS
Messages: 1516
Registered: February 2013
|
Senior Member |
|
|
Dear User,
I have attached a spreadsheet containing variables which contain how the Nigeria state names were classified in 2003, 2008 and 2013. The one that is different is the 2003. The spreadsheet shows the state names in the 2003 dataset in the country specific variable SHSTATE. In the 2008, the data processing person for that survey realized the classification was different and created a country specific variable in the 2008 data set to show the 2003 classification. That variable in the 2008 dataset is called S2003ST and contains the same information as SHSTATE in the 2003 data set. In the 2008 dataset SHSTATE shows the classification for 2008. The classification for the state names in the 2013 NDHS are located in a country specific variable called SHSTATE.
The final report for 2003 has Table A.1 Allocation of the sample, P212 Appendix A. You will be able to tell from the table which states are in each classification such as North Central, etc.
The final report for 2008 has state tables beginning on page 317, Appendix A. You will be able to tell from the table which states are in each classification such as North Central, etc.
The final report for 2013 has tables also in Appendix A, starting on page 369 showing the classifications.
All the reports also have tables througout the report which have state as one of the background characteristics. The above is just a quick place to find the classification.
Our final reports can be downloaded from our Publications Tab on our website http://dhsprogram.com/publications/publication-search.cfm
Thank you for your post. Hope this helps.
[Updated on: Thu, 25 September 2014 11:14] Report message to a moderator |
|
|
|
|
|
| Re: Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013 [message #3860 is a reply to message #3856] |
Wed, 25 February 2015 12:51 |
Liz-DHS
Messages: 1516
Registered: February 2013
|
Senior Member |
|
|
Dear User,
In the individual recode file the country specific state variable for Nigeria DHS 2013 is called SSTATE. In the household recode file the country specific variable for state is called SHSTATE. I looked at the weighted frequencies for each of the files and found the variables there. Hope this answers your question. Here is the frequency for SHSTATE:
Item SHSTATE: State
... tbd-name: '.RECODE5.RECH3.SHSTATE'
_____________________________ _____________
Categories Frequency CumFreq % Cum %
_______________________________ _____________________________ _____________
10 Sokoto 817 817 2.4 2.4
20 Zamfara 675 1492 2.0 4.4
30 Katsina 1113 2604 3.3 7.6
40 Jigawa 862 3466 2.5 10.2
50 Yobe 474 3941 1.4 11.6
60 Borno 869 4809 2.6 14.1
70 Adamawa 676 5485 2.0 16.1
80 Gombe 404 5889 1.2 17.3
90 Bauchi 877 6766 2.6 19.9
100 Kano 1882 8648 5.5 25.4
110 Kaduna 1152 9799 3.4 28.8
120 Kebbi 679 10478 2.0 30.8
130 Niger 759 11237 2.2 33.0
140 Abuja 371 11608 1.1 34.1
150 Nasarawa 389 11997 1.1 35.2
160 Plateau 696 12694 2.0 37.3
170 Taraba 430 13124 1.3 38.5
180 Benue 859 13983 2.5 41.0
190 Kogi 877 14860 2.6 43.6
200 Kwara 617 15477 1.8 45.4
210 Oyo 1694 17171 5.0 50.4
220 Osun 968 18140 2.8 53.2
230 Ekiti 700 18839 2.1 55.3
240 Ondo 939 19779 2.8 58.1
250 Edo 760 20539 2.2 60.3
260 Anambra 1252 21792 3.7 64.0
270 Enugu 849 22640 2.5 66.5
280 Ebonyi 528 23168 1.5 68.0
290 Cross River 765 23934 2.2 70.2
300 Akwa Ibom 999 24933 2.9 73.2
310 Abia 781 25714 2.3 75.5
320 Imo 1117 26831 3.3 78.8
330 Rivers 1718 28549 5.0 83.8
340 Bayelsa 502 29051 1.5 85.3
350 Delta 1222 30272 3.6 88.9
360 Lagos 2522 32794 7.4 96.3
370 Ogun 1276 34070 3.7 100.0
_______________________________ _____________________________ _____________
TOTAL 34070 34070 100.0 100.0
|
|
|
|
| Re: Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013 [message #6814 is a reply to message #3856] |
Sun, 19 July 2015 00:09 |
daniel.odekina
Messages: 9
Registered: June 2015
|
Member |
|
|
Hi LouisCW,
How are you doing? I have decided to use the 2008 or 2013 Nigeria dhs datasets for my research but I have a problem that I think you could help me solve. My study population is Edo State but the datasets from the dhs are national data.I have asked the dhs program representatives participating in the dhs online forum to show me where to get the state level data but their reply was this:
"Dear User,
The variable containing the state names is SHSTATE in the household and SSTATE in the indivdual recode. This variable contains a code for each state. When you do your analysis you will need to do your selections for that state code. The state code for Edo in the variables SHSTATE and SSTATE is 250. The SHSTATE and SSTATE variables are country specific variables."
I found the SHSTATE variable and I saw that Edo State has the code 250, but I still have a problem. I tried to search for variables carrying the code '250' or SHSTATE or SSTATE in the downloaded 2013 DHS SPSS files for Nigeria but didn't find anything else specific for the states. Do I have to do any other statistical manipulation before I can get the data for my state of interest-Edo out of the dataset provided?.Please, how do I proceed
from here to get the state-level variables? For instance, if I want to know how many people from Edo State responded to the question 'Educational attainment' (v149, in individual recode), how do I get it? I am not too good in statistics but, if I am shown the steps, I can follow.
Please, help show me the steps.
Thank you,
Daniel
Daniel
|
|
|
|
|
|
| Re: Question about coding for the variable SSTATE for Northern Nigeria in 2003,2008. and 2013 [message #6844 is a reply to message #6819] |
Tue, 21 July 2015 13:59 |
daniel.odekina
Messages: 9
Registered: June 2015
|
Member |
|
|
Hello LouissCW,
Thank you for your time to give me the clue.
I am trying to work my way using the method you have described..but, as I stated earlier, I am an excel newbie. I only know a little bit of SPSS. I know that for those who are good with excel, you have given them the key to all the information about their state of interest, but no so for me. Could you help further by giving me a few more learners guide, please. It will make me feel better. For now my brain hurts when I see the 'if' command. If you spare a piece of your time to look at one of the 2013 datasets for Nigeria in SPSS, and execute the 'if' command to get some information on Edo, you would have given me a fish as well as shown me how to fish. Please help. And if you have any contact who has the 2013 dataset for Edo or the South-South, it will do me a lot of good. Someone has given me the dataset on Edo State / south-south for 2008 but I am looking for the dhs2013 dataset for Edo State as well. Thank you so much.
Daniel
Daniel
|
|
|
|
Goto Forum:
Current Time: Sat Jan 11 15:44:26 Coordinated Universal Time 2025
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
