The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Issue with duplicate mothers (Need help selecting one child per mother)
Issue with duplicate mothers [message #25205] Thu, 15 September 2022 07:50 Go to previous message is currently offline
Messages: 1
Registered: September 2022

I am a medical student doing a project analysing maternal factors associated with ORS-administration to children with diarrhoea in Pakistan (using Children recode DHS data from 2017-18). Unfortunately I have run in to an issue I can't seem to resolve on my own.

Problem Using children's recode as base dataset, some mothers might have several children, resulting in issues where one mothers factors associated with ORS-use might be amplified in the analysis if they have many children who are experiencing diarrhoea simultaneously. I can't figure out a way to produce descriptive statistics showing how many mothers that had more than one child with diarrhoea simultaneously, and thus I am unable to asses how big of an issue this might be. Furthermore I am wondering if there is some SPSS syntax I could use to select one child < age 5 per mother at random so I can work around this issue?

I have already read the thread 6448&&srch=selecting+one+child+per+mother#page_top but the syntax does not seem to work for SPSS.

Read Message
Read Message
Previous Topic: Variables on early initiation of breastfeeding (m34 and v426)
Goto Forum:

Current Time: Wed Jun 19 16:10:50 Coordinated Universal Time 2024