The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » FGC and daughter's line number
FGC and daughter's line number [message #26404] Thu, 16 March 2023 11:38 Go to next message
Daniel Pérez is currently offline  Daniel Pérez
Messages: 10
Registered: May 2022
Dear DHS staff,

I cannot find the age of each of the last circumcised daughters in the Benin 2001 IR survey, which contains information on daughter's FGC. I know I would need to use the variable fg111 "line number of last circumcised daughter" but I don't understand how could I find that, or what's it exactly. My goal is to know the age of every (last) circumcised daughter.

Thank you in advance,

Re: FGC and daughter's line number [message #26439 is a reply to message #26404] Mon, 20 March 2023 16:22 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 345
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The variable fg111 gives the value of bidx for this daughter; bidx is the number of the child in the birth history, in which bidx=1 is the most recent birth, bidx=2 is the next most recent birth, etc. The following Stata lines will pull out the age for the child in the birth history that has bidx equal to fg111.

use "...BJIR41FL.DTA", clear

tab fg111

* The highest value of fg111 (line number of last circumcised daughter) is 11.
* You can use 11 in the loop below or just use 20, the maximum possible value of bidx.

* Remove leading zeroes in subscripts for b8
rename b8_0* b8_*

gen age_fg111=.
forvalues li=1/20 {
replace age_fg111=b8_`li' if fg111==`li'

tab age_fg111
Previous Topic: Percentage of Adolescents (age 10-19) who are married from Household Data
Next Topic: Map with GIS points?
Goto Forum:

Current Time: Mon Mar 27 19:53:06 Coordinated Universal Time 2023