Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

st: merging fuzzy-non-exact data

From   "Ben Hoen" <>
To   <>
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 Hoen
Principal Research Associate
Lawrence Berkeley National Laboratory
Office: 845-758-1896
Cell: 718-812-7589

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index