The DHS Program User Forum
Discussions regarding The DHS Program data and results
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 Go to next message
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 Go to previous messageGo to next message
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 #3856 is a reply to message #2973] Wed, 25 February 2015 11:53 Go to previous messageGo to next message
LouiseCW is currently offline  LouiseCW
Messages: 3
Registered: September 2014
Location: London
Member
Hi,
A very simple follow-on question - I am trying to locate the variable for state of residence in the 2013 NDHS women's file (NGIR6AFL). In 2008, variable v023 contained the data by state but in 2013 both v022 and v023 contain data for region + state + rural/urban residence. Has a variable for state been retained (I cannot locate sh*)?
Many thanks
Louise
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
daniel.odekina is currently offline  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 #6819 is a reply to message #6814] Mon, 20 July 2015 10:24 Go to previous messageGo to next message
LouiseCW is currently offline  LouiseCW
Messages: 3
Registered: September 2014
Location: London
Member
Hi Daniel,
If I understand you correctly, you can just apply the 'if' command.
tab v149 if v023==11
The above command would give me educational attainment for Kaduna state only. I don't know if Edo is 250 in the IR file, I think it might be 25? (Sorry I don't have Stata/NDHS open right now).
Add the svy prefix of course for surveyset analysis.
You can repeat the command format for any variable to restrict the outputs to one state.
Does that help?
L
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 Go to previous message
daniel.odekina is currently offline  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
Previous Topic: State-level data
Next Topic: Education in couple's data
Goto Forum:
  


Current Time: Fri Mar 29 03:17:51 Coordinated Universal Time 2024