Hi Everyone, I am merging two data sets - A and B; Data Set A firstname secondnameinitial thirdname John A Doe John A Doe John A Doe James B Crow Jim C Throw Jonathan D Brown Data Set B Forename1 Forename2Initial Surname ID John A Doe 12345 John A Doe 67890 James B Crow 15123 James B Crow 12518 Jim C Throw 30987 Jane D Scott 23484 I want matches with all of the information from both tables. I am merging on first name, middle initial, and last name using the following code: proc sql; create table want as select * from have a inner join have b on (upper(trim(a.firstname))=upper(trim(b.Forename1))) and (upper(trim(a.thirdname))=upper(trim(b.Surname))) and (upper(trim(a.SecondNameInitial))=upper(trim(b.Forename2Initial))); quit; My question is this: My output is about 10,000 names. How do I identify the duplicate matches that were eliminated during the merge process due to identical names? I can manually look at additional information to determine which names should be properly matched. Thank you!
... View more