The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » merge IR and KR: duplicate line number in IR
Re: merge IR and KR: duplicate line number in IR [message #23359 is a reply to message #23357] Fri, 27 August 2021 16:26 Go to previous messageGo to previous message
schoumaker is currently offline  schoumaker
Messages: 66
Registered: May 2013
Location: Belgium
Senior Member
Hello,
I looked at the Bolivia file. It seems the v002 variable is indeed always equal to 1. Maybe a dwelling variable was used for creating the caseid and not available in the data set.
I think you can just use the caseid variable (the woman's id) that is available in the IR and the KR file to merge these two files. It seems to work in Bolivia, but I did not check in the other countries.
Best,
Bruno



***
use BOIR01FL.DTA, clear
merge 1:m caseid using BOKR01FL.DTA
***


Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain

[Updated on: Fri, 27 August 2021 16:45]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging data files
Next Topic: I share you summary of GPS & survey & year for bulk dowonloaders
Goto Forum:
  


Current Time: Sun Dec 22 10:18:32 Coordinated Universal Time 2024