The DHS Program User Forum: Dataset use in Stata

Home » Data » Dataset use in Stata » Missing data

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

Re: Missing data [message #14886 is a reply to message #14856]

Fri, 11 May 2018 11:29

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

It would be good if you (and other forum users) could always say what survey you are using. Like your question, my answer is generic. Cases with the "not applicable" code should be omitted from any analysis. Usually they will be omitted automatically, because a blank or a dot is not numeric and can't be included in calculations. Cases with missing value codes should also be omitted, and that must be done explicitly with an "if" or "select" statement. It is not a good idea to drop them from the file, because then you lose cases that are non-missing on other variables you may want to analyze in the same run. It is best to construct a new variable with a new name. For example, with hw70 you could call the recode "hw70r" or "HAZ". In Stata I would do something like this to go from hc70 (the name in the PR file) to stunted:

gen stunted=0
replace stunted=1 if hc70<-200
replace stunted=. if hc70<-600 | hc70>600
summarize stunted [iweight=hv005/1000000] if hv103==1

Report message to a moderator

[Message index]

		Missing data By: nwegbus on Tue, 08 December 2015 17:07
		Re: Missing data By: Bridgette-DHS on Fri, 11 December 2015 07:32
		Re: Missing data By: nwegbus on Fri, 11 December 2015 08:52
		Re: Missing data By: user-rhs on Fri, 11 December 2015 21:44
		Re: Missing data By: Marejoha on Thu, 22 March 2018 08:43
		Re: Missing data By: Bridgette-DHS on Wed, 28 March 2018 07:58
		Re: Missing data By: boyle014 on Sun, 06 May 2018 18:33
		Re: Missing data By: Hassen on Wed, 09 May 2018 10:36
		Re: Missing data By: Bridgette-DHS on Fri, 11 May 2018 11:29
		Re: Missing data By: Hassen on Sun, 13 May 2018 14:31
		Concentration Index By: danelnya on Fri, 01 July 2016 10:02
		Re: Concentration Index By: Bridgette-DHS on Tue, 05 July 2016 12:44
		Re: Missing data By: filotempo on Fri, 09 June 2017 09:04
		Re: Missing data By: Bridgette-DHS on Mon, 12 June 2017 07:47

Previous Topic:	table replication
Next Topic:	Discrepancy in stunting, wasting, underweight prevalence for Nepal DHS 2001

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 2 00:02:58 Coordinated Universal Time 2024