| 
		
			| Issue with duplicate mothers [message #25205] | Thu, 15 September 2022 07:50  |  
			| 
				
				
					|  erik.cl Messages: 1
 Registered: September 2022
 | Member |  |  |  
	| Hello, 
 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  https://userforum.dhsprogram.com/index.php?t=tree&goto=1 6448&&srch=selecting+one+child+per+mother#page_top but the syntax does not seem to work for SPSS.
 
 Thanks!
 
 |  
	|  |  |