The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging data

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

Re: Merging data [message #10191 is a reply to message #10190]

Thu, 07 July 2016 08:00

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

You are apparently trying to merge the MR and PR files. The MR file for this Kenya survey has 12, 819 cases and the age range is 15-54. No one is younger than 15 in the MR (or IR) files. It's not that you have lost hv105; rather, you have no cases with age<15 in the MR file.

Note that for the matched cases, there can be some discrepancies between age in the PR file (hv105) and age in the MR file (mv012). The age in the MR file comes directly from the man, and is assumed to be more accurate than the age in the PR file, which is provided by the household respondent, who MAY be the same person but may be someone else. (Similarly for the IR file and v012.)

I see the line "save "...KEMR70FL.DTA", replace". You should never replace one of the basic recode files with an altered version but the same name. This can cause you endless trouble.

Report message to a moderator

[Message index]

		Merging data By: Lukresha on Thu, 07 July 2016 06:18
		Re: Merging data By: Bridgette-DHS on Thu, 07 July 2016 08:00
		Re: Merging data By: Lukresha on Thu, 07 July 2016 08:27
		Re: Merging data By: Bridgette-DHS on Thu, 07 July 2016 12:19

Previous Topic:	2014 Kenya DHS merging household and men's datafile
Next Topic:	merging male and female hiv data to couples data (DRC)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 22 18:34:31 Coordinated Universal Time 2025