The DHS Program User Forum: Fertility » Children under 5 in Women's File

Home » Topics » Fertility » Children under 5 in Women's File (Coding for childen under 5)

Show: Today's Messages :: Show Polls :: Message Navigator

Children under 5 in Women's File [message #22780]

Fri, 07 May 2021 16:42

wavogo
Messages: 14
Registered: December 2015
Location: Normal, Illinois

Member

Dear DHS,

I was hoping I can get some help re-coding for women with children under 5. I am using the 2016 South African DHS. I have CEB and number of surviving children but specifically need a dichotomous indicator of women who have any children under the age of 5.

Thank you so much for any help or hints.

Report message to a moderator

Re: Children under 5 in Women's File [message #22786 is a reply to message #22780]

Mon, 10 May 2021 10:01

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

This is a little tricky. There may be another way, but here is one way to do it. "temp.dta" is a sorted version of the KR file that has to be saved somewhere.

use... ZAKR71FL.DTA
keep if b5==1
keep v001 v002 v003
egen living_child_under5=seq(), by(v001 v002 v003)
keep if living_child_under5==1
sort v001 v002 v003
save e:\DHS\DHS_data\scratch\temp.dta, replace

use... ZAIR71FL.DTA
sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\temp.dta
replace living_child_under5=0 if living_child_under5==.
tab living_child_under5,m

Report message to a moderator

Re: Children under 5 in Women's File [message #22788 is a reply to message #22786]

Mon, 10 May 2021 17:10

wavogo
Messages: 14
Registered: December 2015
Location: Normal, Illinois

Member

Thank you so much, Bridgett and Tom from DHS, that worked perfectly!

Please allow me to ask another question:

I am trying to study determinants of women's labor force participation (and employment) but I have only currently employed v714. Would you by any chance have suggestions on how to approach re-coding labor force participation (e.g. 0= unemployed; 1= employed and 2= not participating) or any other suggestions you may be able to help me with.

Thank you so much!

Winfred

Report message to a moderator

Re: Children under 5 in Women's File [message #22796 is a reply to message #22788]

Tue, 11 May 2021 09:34

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

If you do "tab v717 v714" you will see that some of the women who are not currently working (on v714) do give an occupation (on v717). A possible interpretation would be that such women are in the labor force but not employed. However, I expect there will be some classification error.

Report message to a moderator

Previous Topic:	Please help! DHS Malawi youth-specific
Next Topic:	Total Fertility Rates for India

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 10 18:23:54 Coordinated Universal Time 2025