Hi, I am trying fuzzy string matching from two files using 'dtalink' package. In both files I have alphanumeric firmname 1800flowerscom, 7eleven and 3m.
'dtalink' only matches 1800flowerscom and 7eleven from both file but not the 3m. I was wondering why. To add a blank at both ends of the string, I use the code: gen newfirmname = " "+firmname+" "
Fuzzy matching code: dtalink firmname 10 0 using file1, block(firmname_f | firmname_l ) cutoff(10) calcweights
Thanks.
Related Posts with Fuzzy matching alphanumeric name
stcox and stcrregHi guys: I have a question regarding stcox and stcrreg. i try to find how does the independent varia…
Leading zeros for displaying scalarsI would like to take the results of scalars and generate a new macro variable. An example is shown b…
Filling in missing Data in time-series using interpolationI have a database on Size and Return for every day in a year. It looks like this: Day Return Size 1…
Wald test for logistic regression - measuring whether a=bHi, I'm running logistic regressions. I'd like to know whether dependent variable a is (statistical…
Collapse to the meanHello, A very trivial question. I would like to collapse to the mean by converting the daily date to…
Subscribe to:
Post Comments (Atom)
0 Response to Fuzzy matching alphanumeric name
Post a Comment