The DHS Program User Forum: Dataset use in Stata » Discrepancy between household and household members datasets

Home » Data » Dataset use in Stata » Discrepancy between household and household members datasets

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

Re: Discrepancy between household and household members datasets [message #9745 is a reply to message #9678]

Thu, 12 May 2016 08:57

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

I think there are two problems here. The first one is that you may think the line number in the household file is given by hv003. Actually the line number is hvidx. hv003 is the line number of the household respondent. Second, education is years is given in two places. One is for everyone (above a cutoff age) in the household file and it is given as hv107. However, it is also asked in the survey of women. That response is carried over to the PR file as ha67. That variable, not hv107, is used for coding the education level of the mother. Open BJ61IRFL.dta and enter this line: "list hv001 hv002 hv003 hvidx hv101 hv104 hv105 hc62 ha67 hv107 if hv001==1 & hv002==22, table clean". You will get the following, and then you will see that hc62 is correct.

index.php?t=getfile&id=556&private=0

Attachment: discrepancy.jpg
(Size: 37.99KB, Downloaded 870 times)

Report message to a moderator

[Message index]

		Discrepancy between household and household members datasets By: mic321 on Thu, 05 May 2016 08:06
		Re: Discrepancy between household and household members datasets By: Bridgette-DHS on Thu, 12 May 2016 08:57

Previous Topic:	Variables missed after appending two de-normalized DHS datasets
Next Topic:	How to download only few variables from the DHS dataset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 11 10:50:20 Coordinated Universal Time 2025