Convert a string variable

[Sang-Min Park]

Hi,

I have two data set. First one contains (full) university name variable (about 7100 univ and colleges) and zip code variable. The name in this file is full names like Arizona State University. Second one contains university name variable (about 600 universities) and other variables. I want to match these two data using university name. I will use the second data after adding zip code variable. But the university names in the second data is shortened like this: Arizona State U. or Babson C. Due to this, Stata completely failed match two files. I used "match" command.

So, my question is how to convert Arizona State U. or Babson C. in the strings into full university or college names in the second data file.

Thank you in advance.

[Clyde Schechter]

This sounds like a job for Julio Raffo's -matchit- command, available from SSC.

[David Benson]

Also, I would take a look at the Statalist post here (for someone tackling a similar problem)

[Sang-Min Park]

Thank you all for the recommendation. I followed the recommendations, but I still need to fix manually^^