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

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: 2804
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

[Message index]

		Children under 5 in Women's File By: wavogo on Fri, 07 May 2021 16:42
		Re: Children under 5 in Women's File By: Bridgette-DHS on Mon, 10 May 2021 10:01
		Re: Children under 5 in Women's File By: wavogo on Mon, 10 May 2021 17:10
		Re: Children under 5 in Women's File By: Bridgette-DHS on Tue, 11 May 2021 09:34

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 Jun 1 08:58:22 Coordinated Universal Time 2023