Re: Merge BR & HW data [message #30617 is a reply to message #30613] |
Wed, 08 January 2025 14:11 |
Janet-DHS
Messages: 935 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
The second version of your merge program look ok. This should be a 1:1 merge. You do not want to select on _merge=3, because children who died are not in the HW file. They will have _merge=1 or 2, depending on which file is the "using" file. (Cases in only that file get _merge=2.)
In the KR or BR file the children who died have b16=., and children who are living but not in the household have b16=0. They will also not be in the HW file. You need to figure out what to do with them....
|
|
|