The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Geographic Data » Merging child recode with DHS GPS data (Merging child recode with DHS GPS data )
Merging child recode with DHS GPS data [message #20077] Wed, 23 September 2020 10:50 Go to next message
aisshwaryya
Messages: 3
Registered: July 2020
Location: Washington, D.C.
Member

Hi team,

I merged the DHS child recode with the corresponding year's DHS GPS data for several countries for several waves each with an aim to get the latitude and longitude for the cluster corresponding to each child. For 3 waves of The Philippines (2003, 2008 and 2015) and 1 wave of the Zimbabwe (2015), a total of 38 DHS coordinates did not merge with any children (_merge == 2, i.e., 38 not merged from using). This means there are 38 clusters for which cluster coordinates are available, but the child file has no children in those clusters.

This seems odd to me - why are there multiple clusters with no children of interviewed mothers in those clusters? Am I missing something here? Thanks in advance for your guidance!

Note: I merged using DHSCLUST variable.


Aishwarya
Re: Merging child recode with DHS GPS data [message #22050 is a reply to message #20077] Mon, 25 January 2021 08:22 Go to previous messageGo to next message
aisshwaryya
Messages: 3
Registered: July 2020
Location: Washington, D.C.
Member

aisshwaryya wrote on Wed, 23 September 2020 10:50


Hi team,

I merged the DHS child recode with the corresponding year's DHS GPS data for several countries for several waves each with an aim to get the latitude and longitude for the cluster corresponding to each child. For 3 waves of The Philippines (2003, 2008 and 2015) and 1 wave of the Zimbabwe (2015), a total of 38 DHS coordinates did not merge with any children (_merge == 2, i.e., 38 not merged from using). This means there are 38 clusters for which cluster coordinates are available, but the child file has no children in those clusters.

This seems odd to me - why are there multiple clusters with no children of interviewed mothers in those clusters? Am I missing something here? Thanks in advance for your guidance!

Note: I merged using DHSCLUST variable.


Aishwarya
Re: Merging child recode with DHS GPS data [message #22073 is a reply to message #20077] Thu, 28 January 2021 01:02 Go to previous message
Bucher is currently offline  Bucher
Messages: 1
Registered: January 2021
Member
Hello,
I'm a researcher from Lumuss team and need help with the topic of impacts of air pollution on Child Health. I need to use the DHSCLUST variable in my Statalist report and then explain it in my case study for MEASURE Evaluation. I have to construct a trimester pollution exposure and calculate the mean PM2.5 for each cluster and each month.


dhsprogram.com/data/Merging-Datasets.cfm Merging Datasets: case study domyhomeworkonline

[Updated on: Thu, 28 January 2021 01:03]

Report message to a moderator

Previous Topic: Peru 2007 GPS clusters contains the 2004 clusters
Next Topic: Matching regions from previous DHS rounds
Goto Forum:
  


Current Time: Wed Dec 8 10:14:25 Coordinated Universal Time 2021