The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Dropping mothers' records without dropping the child's
Re: Dropping mothers' records without dropping the child's [message #9106 is a reply to message #9103] Thu, 11 February 2016 09:12 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2411
Registered: February 2013
Senior Member
Here is another response from Senior DHS Stata Specialist, Tom Pullum:


Yes, if you use "drop" then you will lose the record entirely. In your example, it sounds like women should be the unit of analysis and you should be using the IR file. The number of children born in the past five years is v208. Perhaps you want a command such as this: summarize v438 if v208>1. Note that v438 includes special codes in the range 9994 to 9999, so it would be better to say summarize v438 if v438<9994 & v208>1. Another possibility would be tab v208 if v438<9994, summarize(v438), which would include women with no births or one birth, but you could just focus on women with more than one birth.

If you use the KR or BR files to study women, then each woman (only mothers) will appear once for every child born in the past five years. I doubt that you want that kind of multiple counting of women. Or perhaps you want to relate a characteristic of the child to a characteristic of the mother. For example, you could be studying the relationship between the mother's BMI and whether the child is stunted, underweight, overweight, or wasted. If so, you could remove the women who had one child by including "...if hwidx>1" in the estimation command, before the comma.

In these examples I am omitting the weights; in real life you would want to include them. Note that in the KR and BR files, bidx, hidx, midx, and hwidx are the same.

If there is some other reason why you are using the KR or BR file to analyze women, I'd be interested to hear what it is. Don't hesitate to ask again if I am not answering your question.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Women's status module
Next Topic: How to identify ANC and Instuitional Delivery variables from the 2011 Ethiopian DHS?
Goto Forum:
  


Current Time: Wed Oct 27 05:55:03 Coordinated Universal Time 2021