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

st: Re: string

From   "Michael Blasnik" <>
To   <>
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" <>
To: <>
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?
*   For searches and help try:

© Copyright 1996–2019 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index