The DHS Program User Forum
Discussions regarding The DHS Program data and results
Today's Messages (off)  | Unanswered Messages (on)

Forum: Dataset use in SPSS
 Topic: Selecting one child per mother
Selecting one child per mother [message #16448] Wed, 16 January 2019 11:54
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?


Current Time: Sat Jan 19 14:24:29 Eastern Standard Time 2019