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: 2345
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.

Report message to a moderator

[Message index]
 
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:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Fri Jul 23 20:33:58 Coordinated Universal Time 2021
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government.