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  |
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 |
|
|
|
Current Time: Sun Dec 22 11:21:06 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
