The DHS Program User Forum: Child Health » declaring child survey in Stata

Home » Topics » Child Health » declaring child survey in Stata

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

Re: declaring child survey in Stata [message #3915 is a reply to message #3914]

Thu, 05 March 2015 15:48

Trevor-DHS
Messages: 808
Registered: January 2013

Senior Member

1a) Why are you pooling the data? What benefit do you get from pooling the data over running two separate analyses? Are you trying to compare changes over time?
1b) You cannot use the PSU and stratum variables as they are. You need to create new PSU and stratum variables that are specific to each survey, e.g. egen newpsu = group(survey_year v001) and egen newstrata = group(survey_year v023)
1c) You probably have to denormalize the weights for your analysis. There are several posts on the forum about denormalization.
1d) your svyset command should look more like svyset newpsu [pweight=wgt], stratum(newstrata) where wgt is the denormalized weight. Even if you weren't denormalizing, you would need to first divide v005 by 1000000, but as you are pooling data you should be denormalizing the weights.

2) If you don't use svyset and svy: regress (or similar commands) then your tests of significance will be incorrect.

3) For the weight, see how it is used above in the svyset command. Whenever you use an svy: command Stata will refer to the weight in the svyset command.

4) Using the weight when not using the svy commands:

gen wgt=v005/1000000
tab var1 var2 [iw=wgt]

Using the weight with the svy commands:

gen wgt=v005/1000000
svyset v001 [pweight=wgt], stratum(v023)
svy: tab var1 var2

[this assumes the strata are in v023 - sometimes they are in v022 and sometimes they need to be created. See other posts concerning the strata variables to use.]

5) The variables you mention are standard variables, but I would never copy and paste data as you suggest. You should use the commands for combining datasets: http://www.stata.com/manuals13/u22.pdf

Report message to a moderator

[Message index]

		declaring child survey in Stata By: musti on Thu, 05 March 2015 11:04
		Re: declaring child survey in Stata By: Trevor-DHS on Thu, 05 March 2015 15:48
		Re: declaring child survey in Stata By: musti on Fri, 06 March 2015 05:46
		Re: declaring child survey in Stata By: musti on Fri, 06 March 2015 11:14
		Re: declaring child survey in Stata By: musti on Fri, 06 March 2015 18:20
		Re: declaring child survey in Stata By: Trevor-DHS on Mon, 16 March 2015 21:27
		Re: declaring child survey in Stata By: musti on Wed, 01 April 2015 08:25
		Re: declaring child survey in Stata By: Trevor-DHS on Thu, 02 April 2015 11:19
		Re: declaring child survey in Stata By: Reduced-For(u)m on Thu, 02 April 2015 13:07
		Re: declaring child survey in Stata By: habt_lancs on Sun, 08 October 2017 12:12
		Re: declaring child survey in Stata By: Reduced-For(u)m on Sun, 08 October 2017 16:52
		Re: declaring child survey in Stata By: habt_lancs on Sun, 08 October 2017 17:52
		Re: declaring child survey in Stata By: Reduced-For(u)m on Sun, 08 October 2017 21:11
		Re: declaring child survey in Stata By: habt_lancs on Mon, 09 October 2017 06:54
		Re: declaring child survey in Stata By: habt_lancs on Mon, 09 October 2017 19:05
		Re: declaring child survey in Stata By: Reduced-For(u)m on Wed, 11 October 2017 13:26
		Re: declaring child survey in Stata By: habt_lancs on Wed, 11 October 2017 16:56
		Re: declaring child survey in Stata By: habt_lancs on Mon, 11 December 2017 07:57
		Re: declaring child survey in Stata By: Reduced-For(u)m on Mon, 11 December 2017 16:46
		Re: declaring child survey in Stata By: habt_lancs on Mon, 11 December 2017 16:52
		Re: declaring child survey in Stata By: habt_lancs on Tue, 12 December 2017 18:54
		Re: declaring child survey in Stata By: Trevor-DHS on Mon, 18 December 2017 17:47

Previous Topic:	Merging data sets: Namibia DHS 2013
Next Topic:	Birth weight data for Mexico, 1987?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 16 05:52:18 Coordinated Universal Time 2025