The DHS Program User Forum: Merging data files » coverage of variables v717 and mv717 in Mali V and VI waves

Home » Data » Merging data files » coverage of variables v717 and mv717 in Mali V and VI waves

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

Re: coverage of variables v717 and mv717 in Mali V and VI waves [message #22244 is a reply to message #22192]

Wed, 17 February 2021 09:03

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

You can merge information from the household head with the children in the household with the following steps. Open the PR file and enter "keep if hv101==1" . That will reduce the file to just the household head, one and only per household. Then "rename hv001 v001", "rename hv002 v002", "sort v001 v002" , and then "merge v001 v002 using KR.dta", where KR.dta has been sorted on v001 and v002. You don't need to specify the child's ID code (which is bidx) in this merge. Just using the cluster and household ID codes for the household head and the child (or children) in the household will do it. I recommend that you reduce to the variables you plan to use, before doing the merge. No need to carry along a lot of variables you don't plan to use.

Report message to a moderator

[Message index]

		coverage of variables v717 and mv717 in Mali V and VI waves By: bcleite on Mon, 08 February 2021 10:25
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: Bridgette-DHS on Tue, 09 February 2021 08:56
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: bcleite on Tue, 09 February 2021 09:38
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: Bridgette-DHS on Tue, 09 February 2021 10:47
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: bcleite on Wed, 10 February 2021 02:40
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: Bridgette-DHS on Wed, 17 February 2021 09:03
		Re: coverage of variables v717 and mv717 in Mali V and VI waves By: bcleite on Thu, 18 February 2021 03:41

Previous Topic:	MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.
Next Topic:	Merging variables of mothers' health status in IR file into KR file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 16 12:04:46 Coordinated Universal Time 2025