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 #22177 is a reply to message #22174]

Tue, 09 February 2021 09:38

bcleite
Messages: 7
Registered: June 2018

Member

Dear,

thanks for your feedback. I illustrate my issue further (with the file names).

My goal is to match household-level information on work occupations from MLCR53FL.dta to the children's recode (MLKR53FL.DTA). I find that about 75% of the households (identified with v000 v001 v002 v007) in the children recode are not present in the couple recode.

An illustration of the code I am using (in Stata):

use MLCR53FL.DTA // load couple recode
gen agric = mv717==10 // dummy for male member working on agriculture
collapse (mean) agric, by(v000 v001 v002 v007) // average male individuals at the household level working in agriculture
save "temp.dta", replace

* merging to children's recode:
use "data/DHS MAL/data occupation/MLKR53DT/MLKR53FL.DTA", clear // load children recode
merge m:1 v000 v001 v002 v007 using "temp.dta" // merging it

tab _merge // about 75% of the households of the children are not present in the couple's recode

Does that expose my issue clearer?

Thanks in advance.

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: Sun Oct 26 08:28:26 Coordinated Universal Time 2025