Home » Data » Dataset use in Stata » Strange Issues w/ Data Formatting from DHS (Data received from DHS seems to be formatted in a way that makes data extraction impossible (longer description below))
Re: Strange Issues w/ Data Formatting from DHS [message #29220 is a reply to message #29170] |
Sun, 12 May 2024 13:54 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
yyumeee
Messages: 2 Registered: May 2024
|
Member |
|
|
Sorry to bother, I was having some problems with some merging on the WI datasets.
My study requires assigning WI values to certain locations, without really needing to connect the WI dataset to the HR dataset, but in order to connect to the GPS Dataset I need the DHSCLUST variable which is obtainable through the HR dataset (var hv001).
I followed the steps detailed in the GitHub document, but R doesnt merge HR and WI datasets, since the whhid in the HR dataset created to merge with the whhid of the WI dataset don't seem to match. The problem looks to be in the fact that thw whhid are written in a slight different way (HR dataset has a blank space between the two numbers, whereas WI does not).
Is there a way to be able to fix this (since I need to perform this task on multiple countries, this needs to be easily iterable)?
Alternatively, if there can be a way to directly merge the WI and GPS datasets without needing the HR dataset, that would be great (I guess the first number of the whhid corresponds to the DHSCLUST, but the problem is the same in that for double digits clusters + double digits households ids there is no blank space to separate the two, so that the whhid 1028 could very well mean both cluster 10 household 28 or cluster 102 household 8).
Thank you in advance.
[Updated on: Sun, 12 May 2024 14:05] Report message to a moderator
|
|
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Strange Issues w/ Data Formatting from DHS
By: tednoel on Sat, 13 April 2024 08:17
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Thu, 18 April 2024 10:07
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Mon, 29 April 2024 08:04
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Mon, 29 April 2024 11:54
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Wed, 01 May 2024 12:02
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Wed, 01 May 2024 14:40
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Thu, 02 May 2024 08:46
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Thu, 02 May 2024 18:12
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: yyumeee on Sun, 12 May 2024 13:54
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: yyumeee on Mon, 13 May 2024 13:12
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Tue, 11 June 2024 06:07
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
By: tednoel on Tue, 11 June 2024 10:50
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Strange Issues w/ Data Formatting from DHS
|
Goto Forum:
Current Time: Sun Sep 1 17:43:28 Coordinated Universal Time 2024
|