Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Adding a blank space at the end of a variable in preparation for reclink
From
Matthew Krauchunas <[email protected]>
To
[email protected]
Subject
st: Adding a blank space at the end of a variable in preparation for reclink
Date
Sun, 1 Aug 2010 20:59:41 -0400
Hello,
I am trying to clean up street addresses in preparation for a fuzzy
merge via reclink. I want to change st --> street, ave --> avenue, rd
--> road etc. I am running into a problem though as those characters
are normally at the end of a string. Thus, I cannot use commands
like:
replace street_address=subinstr( street_address, " st", " street ", .)
replace street_address=subinstr( street_address, " ave", " avenue ", .)
replace street_address=subinstr( street_address, " blvd", " boulevard ", .)
Because it will change street names like "Stover" in street over. I
am thinking of adding an extra space at the end of street_address,
running replace commands, and then removing the extra space via rtrim
command. Does this sound like a good plan of attack? If so, does
someone know how I can add a space the end of each of these
observations?
Thanks!
Matt
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/