The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Selecting one child per mother (Women's decision-making and child malnutrition status)
Selecting one child per mother [message #16448] Wed, 16 January 2019 11:54 Go to previous message
caroline.mckenna is currently offline  caroline.mckenna
Messages: 1
Registered: January 2019

I am an undergraduate student investigating the association between women's decision-making variables (participation in decisions regarding spending income, her healthcare, major household purchases, visits to family and relatives) and stunting and wasting in her children under five. I am using the 2013-14 Democratic Republic of the Congo DHS.

I already created dichotomous variables for "Stunting Status" where HAZ< -2 SD and "Wasting Status" where WHZ < -2 SD according to WHO child growth standards. I currently have the child data set with linked mothers, but the problem is that the mothers are duplicated if they have several children (ex if a mother has 6 children, her data is counted 6 times). Now, I would like to randomly select one child per mother to create "mother-child pairs." Specifically, I would like to classify a mother-child pair as "exposed/malnourished" if the mother has at least one child who is stunted/wasted. How would I do this?

Read Message
Read Message
Previous Topic: mean and median duration of breastfeeding
Next Topic: Calculating cases for IYCF
Goto Forum:

Current Time: Sun Jul 14 09:17:03 Coordinated Universal Time 2024