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 #29167 is a reply to message #29166]

Thu, 02 May 2024 10:03

Trevor-DHS
Messages: 803
Registered: January 2013

Senior Member

Hi
The problem is that hhid does not exist in the WI file, but whhid does. You had the right idea when you created whhid in the PR data using the clonevar statement, but then you dropped it immediately by not including it in the keep statement. So you need to include whhid in the keep statement and then use it in the next few statements as follows:

use TZPR41FL.dta, clear
* keep the variables you want from the PR file
clonevar whhid = hhid
keep whhid hhid hv005 hv007 hv025 hv219
sort whhid
merge m:1 whhid using TZWI41FL.dta

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: Fri Nov 29 20:27:30 Coordinated Universal Time 2024