The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » General Data Questions » Grouping ethnic categories for Nigeria DHS 2008 and 2013
Grouping ethnic categories for Nigeria DHS 2008 and 2013 [message #14028] Sun, 04 February 2018 18:55 Go to next message
catherino222 is currently offline  catherino222
Messages: 4
Registered: February 2017
Location: London ON
Member
I am working with the Nigeria DHS of 2008 and 2013, and I want to pool the two datasets. However, ethnicity was coded differently. Ethnicity for 2008 has 11 categories while 2013 has over 200. I would like to know how to group ethnicity for 2013 to produce a final list of major ethnic groups that are comparable with those for 2008.

Thank you
Catherine
Re: Grouping ethnic categories for Nigeria DHS 2008 and 2013 [message #14043 is a reply to message #14028] Tue, 06 February 2018 08:33 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

As you say, the 2008 survey (NG53) has two variables for ethnicity. In the IR file, the variable with 11 categories (one of which is "others") is v131. The other variable, s119, has MANY categories. You can get all the category numbers and labels with "label list v131 s119" and you can find which categories of s119 were put into which categories of v131 with, for example, "tab s119 if v131==1, nolabel".

The 2013 survey (NG6H) appears only to have the detailed list, as you note, and that's given as v131. You can get all the category numbers and labels with "label list V131". It's unfortunate that there is not a grouped list. However, if you look at how the categories of s119 were mapped into v131 in the 2008 survey, you should be able to apply the same mapping or recode to v131 in the 2013 survey. I believe the codes for the detailed ethnic categories were not consistent, so be careful....

Previous Topic: Homes/samples participating in multiple surveys
Next Topic: Number of woman and children by wealth quintile
Goto Forum:
  


Current Time: Thu Mar 28 11:53:16 Coordinated Universal Time 2024