The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » append and merge data of 40 data set (append and merge HR MR & IR of sub-saharan countries)
append and merge data of 40 data set [message #22905] Wed, 02 June 2021 04:14 Go to previous message
JaneQuan is currently offline  JaneQuan
Messages: 11
Registered: June 2021
Member
Hi! It's Jane.

I am working on Sub-saharan data of 40 datasets(some countries have one-year datasets, and others have more than one-year dataset). and I need:
a) HV244, HV245, AGLANDAMT2, AGLANDWHO, PLOTSOWNO variables from HR;
b) MV714 (CURRWORKMN), MV717 (WKCURRJOBMN), MV745B (MANOWNLAND), MV745D (MANLANDDEED), MANLANDSELL, MV739 (DECMANEARN), MV743A (DECMANHCARE), MV743B (DECBIGHHMN), MV744A (DVAGOOUTMN) from MR;
c) V717 (WKCURRJOB), V714 (CURRWORK),V745A (FEMOWNHOUSE), V745B (FEMOWNLAND),V745D (FEMLANDDEED),FEMLANDSELL (FEMLANDSELL),INHERITLANDHOUSE, V739 (DECFEMEARN), V746 (WKEARNSMORE),V743F (DECHUSEARN), V743A (DECFEMHCARE),V743B (DECBIGHH),V743D (DECFAMVISIT),V744C (DVAARGUE) from IR.

I have downloaded all the STATA data, and I am going to pool them together. my steps will firstly append all the HR, MR, and IR data respectively, and then merge MR and IR onto the HR dataset.
but I found observations among HR, IR, and MR are all different within the same country. how should I merge them? --the household ID and caseid are slightly different since the caseid includes both household id and respondent id.

by the way, all other data are collected from the Standard DHS survey, but Senegal's from 2014-2016 is the continuous DHS Survey. and Senegal Continuous DHS in 2014 and 2016 has two datasets in HR, MR, and IR respectively, such as
Senegal: 2014 "SNHR6RFL/SNHR70FL" "SNIR6RFL/SNIR70FL" "SNMR6RFL/SNMR70FL";
Senegal: 2016 "SNHR7IFL/SNHRG0FL" "SNIR7IFL/SNIRG0FL" "SNMR7IFL/SNMRG0FL"
Which one should I use?

Any hint will be appreciated. thanks!

[Updated on: Wed, 02 June 2021 04:17]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Calculation of child marriage rates and v511 from PR dataset
Next Topic: pooling countries to run fixed effect
Goto Forum:
  


Current Time: Tue Oct 4 22:09:37 Coordinated Universal Time 2022