Hi, I have two data files I want to merge. The issue is I don't have an ID column shared by both files. Instead, I want to merge based off other criteria like matching email addresses.
How could I merge with the following rules:
if two email addresses match, the records match.
Otherwise, if the name and date of birth match, it's a match.
Also, how could I account for differences in names such as "David" and "Dave"?
Would the merge command work in this situation?
Related Posts with Merging two files on multiple criteria and imperfect matching?
histogram for continuous variableHello, I'm new in the forum and have a question for you. I work with panel data coming from a resea…
Tracking dropped observation countsI am using Robert Picard's excellent project package. I would like to keep track of the number of ob…
Exporting what was done on Stata onto MathlabDear Stata users, Code: * Example generated by -dataex-. To install: ssc install dataex clear inp…
Multi-groups or aggregated binary groups in treatment variable for difference-in-difference models?Hi Statalisters I'm doing a difference-in-difference (DID) analysis and I wonder whether I'm correc…
Simple parallel trends for Difference in DifferenceHello, I am doing a very basic Difference in Difference. I get my results for the DD fine, but for m…
Subscribe to:
Post Comments (Atom)
0 Response to Merging two files on multiple criteria and imperfect matching?
Post a Comment