The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Egypt » Genital Cutting Module Data
Genital Cutting Module Data [message #8813] Mon, 21 December 2015 11:47 Go to next message
lauriejameshawkins is currently offline  lauriejameshawkins
Messages: 1
Registered: December 2015
Location: Atlanta GA
I am working with Egypt DHS data and trying to link the household roster data for each child to the data from the FGMC module which is all in the same data file. However, the _01, _01 etc. markers for the roster do not match up to the _01, _02 designations for the FGMC module data. So when I try to put the data in long form I get FGMC module data (which is only about women/daughters) matching up to male children and also get things like cutting performed at age 8 when the child associated with it is only 5. Can anyone help me figure out how to link this data up so that I can associate the current age and gender etc in the roster with the age at cutting?
Thank you,
Laurie James-Hawkins
Re: Genital Cutting Module Data [message #8912 is a reply to message #8813] Wed, 13 January 2016 07:34 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3063
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

I would have preferred more specificity as to which survey, file, and variable(s) you are working with. I have looked at just the 2014 survey (EG61)to try to answer this question. In that survey, relevant variables referring to the respondent (e.g. g102, whether the respondent has been circumcised) are only included in the IR file. I think you must be talking about g121-g124, which are indexed. g121_** is "is daughter circumcised". In the IR file, g121_** has indexes 01 through 20. It appears to be defined only for surviving daughters under age 20. I checked but cannot find a reliable way to connect the subscripts for g121 in the IR file with the specific children by doing a merge.

g121 does not appear in the KR file, but it does appear, without an index, in the BR file. I think the safest way, and possibly the only way, to link g121-g124 with specific daughters is by using the BR file. I have not checked, but this probably applies to the other surveys, not just the 2014 survey.

Previous Topic: Merging BR and WI in the Egypt 2000 survey
Next Topic: EGYPT DHS 2014
Goto Forum:

Current Time: Thu May 23 05:13:40 Coordinated Universal Time 2024