Hi,
I'm trying to merge two datasets by phone number. In dataset 1, each observation only has one phone number (so just one phone number variable). In dataset 2, each observation has a primary phone number and a secondary phone number (so two different phone number variables). I'd like to merge these two data sets by merging observations where the one phone number in the first dataset matches at least one of the phone numbers in the second dataset. I've looked through the merge documentation but it doesn't seem like there is an option to do this.

Any help would be appreciated!