Hi,

I want to match 2 columns with different patterns of city names (not sorted, no similar observations).

I need to match the names ("upazila_name") with the original city names ("admin3name_en") and gen a city codes ("admis3pcode").

I used machit command, it did not work for me, maybe because it considers row to row matching.

What I suspect is I need to use foreach command with matchit, but I am not sure how?

Or is there any other suggestions, please do. Would be helpful.

glimpse of the data is attached here.

Thanks in advance


Array