Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: merging fuzzy-non-exact data


From   "Ben Hoen" <bhoen@lbl.gov>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: merging fuzzy-non-exact data
Date   Mon, 16 May 2011 17:01:43 -0400

I am trying to merge two panel data sets from two different data
storehouses, both of which kept data over the same period of the same set of
projects.  Each dataset has four variables: id, name, year, state.  The year
and state will be exact matches in the two datasets, but the names do not
exactly match - different naming conventions were used by the two data
gathering companies.  The names will be similar though.  The goal would be
to create a final linking table that had the id's from both storehouses, so
that in the future I can merge them easily.  

Is there any command that allows one to match in a non-exact manner?

Ben

Ben Hoen
Principal Research Associate
Lawrence Berkeley National Laboratory
Office: 845-758-1896
Cell: 718-812-7589
bhoen@lbl.gov
http://eetd.lbl.gov/ea/emp/staff/hoen.html



*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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   |   Site index