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]
Re: st: Fuzzy collapse
From
Steve Nakoneshny <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: Fuzzy collapse
Date
Thu, 26 Jan 2012 09:18:15 -0700
Although I don't have any experience in using it, I would think that this situation may call for -soundex-, check -help string functions- for details.
Steve
On 2012-01-26, at 9:03 AM, Charles Vellutini wrote:
> Dear Statalisters,
>
> I have a string variable holding thousands of search keywords, many of them identical up to a few accents or characters. Here is a typical sample:
>
> keyword
>
> Obs1 télécommandes
> Obs2 télecommandes
> Obs3 télécomandes
> Obs4 telecommandes
> Obs5 télécommande
> etc.
>
> I would like to do a "fuzzy" collapse, that is, to group observations with near-identical keywords. I could write manual multiple -replace-'s to harmonize keywords, but given the size of the dataset and the variety of keywords, that is hardly feasible. I am aware of the -reclink- user-written command for fuzzy merging but that is for merging two datasets, not for collapsing observations within a dataset. It is not immediately evident to me how I could use -reclink- to solve my problem, but maybe that is feasible?
>
> Any suggestion much appreciated.
>
> Thanks,
> Charles
>
>
>
>
>
> *
> * 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/
*
* 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/