The DHS Program User Forum: Dataset use in Stata » Strange Issues w/ Data Formatting from DHS

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))

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

Re: Strange Issues w/ Data Formatting from DHS [message #29166 is a reply to message #29033]

Thu, 02 May 2024 08:46

tednoel
Messages: 12
Registered: April 2024

Member

Hi Trevor, I fixed this line of code- thank you so much. Unfortunately, there is still an error cropping up with respect to the hhid case identifier. Below is the lines of code concerned:

use TZWI41FL.dta
sort whhid
save TZWI41FL.dta, replace

use TZPR41FL.dta, clear
* keep the variables you want from the PR file
clonevar whhid = hhid
keep hhid hv005 hv007 hv025 hv219
sort hhid
merge m:1 hhid using TZWI41FL.dta
clonevar v001 = hv001
clonevar v002 = hv002
clonevar v003 = hvidx
sort v001 v002 v003
save TZPR41FL_temp.dta

use TZIR41FL.dta, clear
sort v001 v002 v003
merge 1:1 v001 v002 v003 using TZPR41FL_temp.dta

Unfortunately, it seems like the wealth index cannot be emrged using either "hhid" or "whhid," as I've received error messages for both iterations of this code (attached in photos). I've been trying to figure out what the issue is and perhaps I shouldn't be using the command "clonevar" and perhaps I should just be renaming the variable entirely? I want to make sure that this is correct.

As always, really grateful for your assistance!

Attachment: Screen Shot 2024-05-02 at 3.43.59 PM.png
(Size: 19.05KB, Downloaded 51 times)
Attachment: Screen Shot 2024-05-02 at 3.44.07 PM.png
(Size: 19.49KB, Downloaded 50 times)

Report message to a moderator

[Message index]

		Strange Issues w/ Data Formatting from DHS By: tednoel on Sat, 13 April 2024 08:17
		Re: Strange Issues w/ Data Formatting from DHS By: Bridgette-DHS on Mon, 15 April 2024 11:02
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Thu, 18 April 2024 10:07
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Fri, 19 April 2024 10:56
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Mon, 29 April 2024 08:04
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Mon, 29 April 2024 11:54
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Mon, 29 April 2024 15:49
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Wed, 01 May 2024 12:02
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Wed, 01 May 2024 13:01
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Wed, 01 May 2024 14:40
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Wed, 01 May 2024 15:50
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Thu, 02 May 2024 08:46
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Thu, 02 May 2024 10:03
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Thu, 02 May 2024 18:12
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Thu, 02 May 2024 19:18
		Re: Strange Issues w/ Data Formatting from DHS By: yyumeee on Sun, 12 May 2024 13:54
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Mon, 13 May 2024 10:59
		Re: Strange Issues w/ Data Formatting from DHS By: yyumeee on Mon, 13 May 2024 13:12
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Tue, 11 June 2024 06:07
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Tue, 11 June 2024 09:57
		Re: Strange Issues w/ Data Formatting from DHS By: tednoel on Tue, 11 June 2024 10:50
		Re: Strange Issues w/ Data Formatting from DHS By: Trevor-DHS on Tue, 11 June 2024 14:12

Previous Topic:	Women who gave birth in the last 2 years
Next Topic:	Household food insecurity index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Sep 1 17:54:26 Coordinated Universal Time 2024