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

st: Preventing 'spreading' on merging files


From   "Mark Clatworthy" <ClatworthyMA@Cardiff.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Preventing 'spreading' on merging files
Date   Wed, 31 Mar 2004 11:28:23 +0100

I have a data set with around 90,000 observations and I am merging it with
another dataset with around 3 million observations.  However, when I merge the
two, the number of '3s' in the _merge variable exceeds the 90,000 in the master
file by a few thousand, indicating that there is more than one observation in
the using file for some of the observations in the working file.

Does anyone know if it is possible to prevent Stata from picking up the
additional observations from the using file (i.e., constraining the observations
merged to the 90,000 in the working file)?

Many thanks in advance
Mark Clatworthy
Cardiff University
*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index