Statalist


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

st: Re: string


From   "Michael Blasnik" <[email protected]>
To   <[email protected]>
Subject   st: Re: string
Date   Mon, 17 Mar 2008 12:16:41 -0400

...
You may want to try out -reclink- available from SSC (-findit reclink-) . It uses the bigram string comparator to assess the degree of match between fields. If you have lots of short strings, you may want to adjust the minbigram option downward to ensure more matches.

Michael Blasnik (author of reclink)


----- Original Message ----- From: "Viktor Slavtchev" <[email protected]>
To: <[email protected]>
Sent: Monday, March 17, 2008 9:48 AM
Subject: st: string



Dear list,
I want to merge two files where the common variable is a string (names of cities). However, there are non systematic differences in the notions.
For example, you can find: "Berlin" in the first file but " Berlin" in the second. In other cases you can find "Rome" and "Roma,IT". Or "Paris, FR" and "Paris/FR"
I was tot able to find any systematics in the notion. I have over 40.000 unique observations.
How can I search for substrings in Stata? For example, for "*Rom*", the largest match between "Rome" and "Roma,IT".
I think this could help to solve some problems. Or does anybody know a better way to deal with such kind of 'bad' data?
thanks
viktor
*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index