Dear Statalist members,
I want to identify the political connections of the firms. For this I have companies officials names and on the other side I have names of the politicians. I want to trace the politicians who are also the company's directors/officials etc. I want to compare two columns having string data, and the names in both columns may have little difference as well. a politician name may appear little different "Muhammad Saleem Khan" in political data column but it may be "Saleem Khan" in firms data column. I have 6000 rows in corporate data column and 440000 rows in political data column. to cut it short every name of the first variable need to be searched in the complete data of the 2nd variable.
Related Posts with Comparing data among two string columns
Store a new variable with unique observations and missing otherwiseHello, Can you please help me with the following issue: I want to compute returns (ret_eom) based o…
foreach issueHi STATA users, I have a data set and code as attached. I want to create new columns with a prefix…
runby/rangestat for the loop problem?Dear All, Is it possible to use runby/rangestat (or others) to speed up the following loop? Note, yo…
conditional ATE in treatment effects estimationHow can one obtain the average treatment effect (ATE) or average treatment effect on the treated (AT…
Extract different parts from one variableDear experts, I have a table like this: Year Violation Year 2010 2005,2006,2007,2008,2009,2010 B…
Subscribe to:
Post Comments (Atom)
0 Response to Comparing data among two string columns
Post a Comment