The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » DHS Burundi 1987
Re: DHS Burundi 1987 [message #20144 is a reply to message #3219] Mon, 28 September 2020 17:14 Go to previous messageGo to previous message
id709nvz is currently offline  id709nvz
Messages: 43
Registered: March 2019
Member
Dear,

I have used this code to merge Ethiopian HW with children's KR file (DHS 2000 AND 2005). The merge doesn't seem ok. could you please highlight on how can I get the desired results? Here is an example of the code I used.

Height/weight measurement for Ethiopian DHS 2000
*Height/Weight measurement
use ETHW41FL.DTA, clear
rename hwhhid caseid
rename hwline midx
sort caseid midx
save ETHW41FL.DTA, replace

*Children-KR file
use ETKR41FL.DTA, clear
sort caseid midx
merge 1:1 caseid midx using "ETHW41FL.DTA"

Result # of obs.
-----------------------------------------
not matched 21,220
from master 10,873 (_merge==1)
from using 10,347 (_merge==2)

matched 0 (_merge==3)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Mozambique: Standard DHS, 2022-23, KR Dataset
Next Topic: Minimum acceptable diet
Goto Forum:
  


Current Time: Sun Sep 22 17:17:13 Coordinated Universal Time 2024