| Re: Merging and appending data files [message #24902 is a reply to message #24860] |
Mon, 01 August 2022 08:40   |
nora-dhs
Messages: 2
Registered: July 2022
|
Member |
|
|
Hi Tom,
thank you very much for your detailed answer!
I have some questions to your recommendations:
- You said it is impossible to merge the IR, MR, and KR files with the HR files. This surprises me, as I followed the "Guide to DHS Statistics, Version May 2020" to do the merging, see 1.51 ff. In Example 1, they match the household characteristics from the HR files to individual children from the KR files, which is exactly what I want to do.
- Why do you recommend to do the merging first and then to append the files?
- I also prefer to use v001 v002 v003 to do the merging rather than the caseid. However, in some cases v001 etc. are missing or wrongly coded, so I need to create them manually from caseid. Do you have any advice on how to do that best? As you said, caseid and hhid have survey-specific variations and differ in length and structure between the surveys, so I can't find a straightforward code that works for all surveys.
Thanks a lot for your help!
All the best, Nora
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
