Hi,
I'm trying to merge two datasets based on a string variable; but the string variables don't match exactly. I further need to do this by group. For instance, if this was my first data set:
Name Age City
John Smith 45 New York
Jane Doe 24 New York
John Smith 30 New Orleans
And this was my second
Name Sex City
Smith, John Q M New York
Jane Doe F New York
Smith, John M New Orleans
How do I merge these two based on the name and grouped by city?
I tried to append the two datasets and then used matchit, but I don't know how to group by city. I'd be super grateful for any help!!