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

st: string

From   Viktor Slavtchev <>
Subject   st: string
Date   Mon, 17 Mar 2008 14:48:03 +0100

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