The DHS Program User Forum: Merging data files » No of children in the household for diarrhoeal prevalence at household level

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)

Show: Today's Messages :: Show Polls :: Message Navigator

No of children in the household for diarrhoeal prevalence at household level [message #15934]

Mon, 08 October 2018 05:43

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

Report message to a moderator

Previous Topic:	Appending datasets of one country for several years
Next Topic:	Appending Indonesian DHS 2007 and 2012

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 11:37:56 Coordinated Universal Time 2024