| Re: Merging child's malaria results from HH member recode dataset with other child data in Child recode [message #2903 is a reply to message #2901] |
Mon, 08 September 2014 16:44   |
kate2
Messages: 15
Registered: May 2014
|
Member |
|
|
Thank you very much for this.
I did the merge in SPSS (Still using this until end of the week) and indicated the following:
that I wanted to merge PR to KR rather than the other way round.
that I wanted to add variables rather than cases
that the key variables to match by were v001, v002 and idmerge (my new variable which represents b16 and hvidx in the relevant datasets)
I then also indicated that the the PR file was a keyed table, in order to -- I think --- add the relevant variables from the PR dataset to the existing cases in the KR dataset. The first time I tried the merge by selecting instead that 'both files provide cases; I had very many new cases (about 46,000) added.
Could you confirm that it is correct to specify the PR file as a 'keyed table' and that I haven't caused problems by doing this.
Thank you again for all your help
Kate
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
