Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: duplicated studyid when merging files


From   [email protected]
To   [email protected]
Subject   st: duplicated studyid when merging files
Date   Fri, 2 Dec 2005 19:55:45 -0600

Hello, 

Have an interesting problem with merging files. 

Wish to import zip codes from an excel file into stata file A. 
Imported zip codes into new stata file B. 
Sorted both files by studyid. 
Merged file B into file A.
Works fine, except that one studyid was duplicated.  _merge variable was 
"3" for both copies. 
Seems that the variable values in the duplicated studyid are the same. 
This is interesting, as file A has 50 variables but file only the studyid 
and zip codes. 

Any reason for this to occur? 

Thank you 

Richard Lenhardt, MD, MPH 
Assistant Professor of Medicine
Division of Pulmonary and Critical Care Medicine
Rush University Medical Center
Chicago, IL 

*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index