The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » No of children in the household for diarrhoeal prevalence at household level (Merging household and KR information for no of children)
No of children in the household for diarrhoeal prevalence at household level [message #15934] Mon, 08 October 2018 05:43
kumarvinay is currently offline  kumarvinay
Messages: 1
Registered: October 2018
Member
I'm trying to find out the household prevalence of diarrhoea i.e no of children with diarrhoea in the household/Total no of children in the household. If i use the de jure no of children in the household file (hv102) and merge with the KR file there are households which have reported zero de jure children but have reported children with diarrhoea in the KR file. I'm using the file for India. Is there any way I can do this?

Alternatively can i remove the dead cases for diarrhoea prevalence from KR file and then create a new varibale with the value 1. Then collapse this by household with the function sum. This would give me the no of children in the household. Is this a right way to do it.


Regards,
Bevin Vinay
Previous Topic: Appending datasets of one country for several years
Next Topic: Appending Indonesian DHS 2007 and 2012
Goto Forum:
  


Current Time: Mon Oct 22 15:09:39 Eastern Daylight Time 2018