Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: problems with merging datasets


From   Ted Anagnoson <anag999@silcom.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: problems with merging datasets
Date   Fri, 11 Jul 2008 08:24:06 -0700

One possibility to check is that one or more of the identifying variables are strings, and the others are numerics....

Ted Anagnoson




At 07:15 AM 7/11/2008, you wrote:

Hello All,
          I am trying to merge 2 datasets using 2 different combinations of
identifying variables, all of which are in the string format.When I first
merge using hs_cd state and zip, I get a reasonably good match, with all but
33 observations matched between the 2(out of a total of about 1800).However,
when I redo the merge using hs_cd state zip and city, the merge completely
fails-not a single obs. is matched b/w the 2.Now, I have checked the city
variable in both datasets for common errors and have been unable to find any
mistakes-both city variables are in capital letters and there exist many
cities with common spellings across both datasets. Can someone please tell me
what I am missing?

Murali Kuchibhotla



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