Hello Stata users:
I am trying to "merge" three data sets. It is my understanding that merge
joins observations, append adds a data set to the end of the existing data
set and joinby forsm pairwise variables etc. I do have a problem and that
is that while most of the observations in the three data sets are common to
all three there are a few that are not, hence, when I attempt to use append
(to add new variables to existing observations) some of the observations
are ignored in the resulting data set. Is there a way to avoid this?
Should I pay special attetion to some particular detail? Like...name of
observations not being exactly teh same in all data sets? Acess to manuals
at this point is not possible since I am out of the country now.
Thanks in advance,
Federico
*
* 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/