The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Latest birth identification in KR file
Re: Latest birth identification in KR file [message #20420 is a reply to message #20417] Fri, 30 October 2020 15:47 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2549
Registered: February 2013
Senior Member

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

If you use the KR file, it can happen that the most recent child is not living. If you only want the youngest child who was actually living and measured, you can do the following:

Open the KR file
keep if hw70<.
sort v001 v002 v003 bidx
egen sequence_living_children=seq(), by(v001 v002 v003)
keep if sequence_living_children==1

The trick here is "egen sequence". If you enter "help egen" you will find a lot of helpful functions.

Of course, there may be some women who had a child in the past five years but they do not have any children who are still alive and were measured.

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Definition of prelacteal feed in Indonesia DHS
Next Topic: BMI India 2015
Goto Forum:

Current Time: Sun Aug 14 01:51:30 Coordinated Universal Time 2022