Mingfeng wrote:
The -merge- command in Stata requires that the variable to merge
uniquely identify observations in the master dataset. But how should
I merge if the variable I would like to merge on does not uniquely
identify master dataset observations?
For instance:
Master: ID GROUP
(multiple IDs could be in the same group)
Using dataset: GROUP GROUPDEMOGRAPHICS
I wanted to do
.merge GROUP using ..., sort
error message r(459): something that should be true of your data is
not;
My final dataset should have each ID as an observation. Is there
something I can do to work around this?
==============================================================
The -sort- option requires the matching key to be unique. If that
is not the case, sort the files before merging and drop the -sort-
option from the -merge- command.
Hope this helps
Svend
__________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone: +45 8942 6090
Home: +45 8693 7796
Email: [email protected]
__________________________________________
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
