| Re: Merging Children and household Colombia 2010 [message #11955 is a reply to message #11934] |
Sun, 12 March 2017 23:38   |
Nathalie
Messages: 3
Registered: March 2017
Location: Montreal
|
Member |
|
|
Thanks for your answer.
Following your suggestion, I did this:
Step 1
PR file : rename hv001 V001; rename hv002 V002; rename hivdx V003 ; sort V001 V002 V003; save PR_using2
IR file : rename v001 V001; Rename v002 V002 ; Rename v003 V003 ; Sort V001 V002 V003 ;
Merge m :1 V001 V002 V003 using PR_using2 ;(not matched from master 0; not matched from using 150938) Rename _merge merge1; Save TEMP_1
Step 2
BR file: rename v001 V001; rename v002 V002; rename b16 V003; sort V001 V002 V003
merge m :1 V001 V002 V003 using PR_using2 ; (not matched from master 23616; not matched from using 136676) ; Rename _merge merge2 ; save TEMP_2
Step 3
TEMP_2; Merge m:1 V001 V002 V003 using TEMP_1 (not matched from master 23616 ; not matched from using 0); Save Finalfile_2010
I have some questions:
1. Have I used the merge command correctly? Is it merge m:1 in the 3 steps?
2. In step 3: What does it mean 'not matched from master 23616'? It is the number of children without mother?
3. In the final file (2010_Finalfile) the variable sh38 (member of a health security system) is the children security system or the mother security system?
4. At the end of the merge in step 3 I have this output:
. merge m:1 V001 V002 V003 using TEMP_1
(label v013 already defined)
(label v014 already defined)
...
(label hv015 already defined)
(label _merge already defined)
Is this a problem? Or it is just that I had the same variables in the two files.
Thanks
[Updated on: Mon, 13 March 2017 00:19] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
