Hi,
I am using two datasets with the aim to merge them according to the name of the place. The first dataset is the 2011 South African data, whereby the variable "sp_name" (which i've made all lower case) has unique individual names of small places in South Africa. The other data set has the variable "suburb" - these individual variable names are not entirely dissimilar to those of sp_name, however there are some cases of misspelling and mismatch. For instance, there are variables for sp_name such as "xx sp" and then for suburb it would just be "xx."
The other problem is that there is a mismatch in the number of observations for each, some missing etc.
I have attempted to understand the reclink and matchit command without much success in using them - I would get the return that "the variable cannot be found" although I did follow the same syntax.
Am I missing something with this problem that would allow for me to solve it conceptually?
Thank you
Related Posts with Merging two datasets by different variable names (fuzzy match) - help with reclink and matchit
Syntax error on "or" commandDear Madam/Sir, I am new to STATA programming. After searching several posts, I make the following …
Including additional interaction fixed effects wHi Statalist, I just joined the community and I would like to ask a question that I couldn’t solve …
Does "reverse" retain as official word?Dear Stata users, I installed a community contributed command -revrs- (SSC) written by Kyle Longest…
Including additional interaction fixed effects in a two way fixed effect modelHi Statalist, I just joined the community and I would like to ask a question that I couldn’t solve …
Accessing the coefficient estimate in a threshold regressionHi, I need your help. When we run a simple regression, we may access the coefficient by typing Cod…
Subscribe to:
Post Comments (Atom)
0 Response to Merging two datasets by different variable names (fuzzy match) - help with reclink and matchit
Post a Comment