| Re: merging IR with GPS data [message #27628 is a reply to message #27542] |
Tue, 12 September 2023 22:03  |
ekowababio
Messages: 4
Registered: February 2017
Location: Kingston, Ontario
|
Member |
|
|
You are encountering an error because the clusters are typically numerically coded, ranging from 1 to 900, for example. This issue arises particularly when you have survey data spanning multiple years. To resolve this, you have two options:
Merge the GPS data with their corresponding survey data before appending.
or
Create a unique ID for the clusters in both the GPS and survey data. In Stata, for the survey data, you can achieve this with the following command:
egen new_cluster_ID = concat(v000 v001), punct(-)
Remember to create a similar variable for the GPS data using the country code (I've forgotten how it is coded) and DHSCLUST. This will help you uniquely identify each cluster for each survey period.
However, there's a caveat to consider for DHS surveys conducted over a two consecutive period, such as 2000/2001. In the GPS data, you might have only one year, e.g., only 2000. This can potentially cause issues when attempting to merge the GPS and survey data using the second approach. I have an R code for addressing this. I need to dig it up and I am not near my pc.
All the best
Prince
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
