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 #29387 is a reply to message #29384]

Tue, 11 June 2024 09:57

Trevor-DHS
Messages: 800
Registered: January 2013

Senior Member

Hi
I don't think I can help much with the issue of pooling data and whether to use weights for your analysis. The thread you provided is a good summary of the issues. The note on denormalization provides information on how to create a weight for pooled data. Remember to create a stratum variable that separates the strata across countries. As for whether you need weights for some types of multivariate analysis, that is a debate that I can't give you a simple answer to - there are people on both sides of the debate. For me, I would tend to use weights unless I had a really good reason not to, but that is my view.

In terms of your code below, one strange thing stood out to me. You have the following line:
generate current_age = hv007 - v010
This appears to be calculating current_age from the year of the household interview (not the individual interview) minus the year of birth from the individual interview. This is a very inaccurate method of calculating age (it will be wrong about half of the time on average), especially as there is a current age variable in the dataset (v012)! I think you should be using v012.

Also, you are calculating indicators for married by age 18 and married by age 15. The married by age 15 indicator is incorrectly including 15. This should use v511 < 15, not <=.

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 Jul 28 00:20:01 Coordinated Universal Time 2024