Name Validation

[oolugboji]

Firstname	lastname
John & Susan	Wood , Temple
John, Mike, Dana	Brown, Kent,
Terry, Nelson, Reobert	Rohr & Little

I have a large table(about 100k rows) as above that contains the multiple first names, and multiple last names which I need to validate against my names library. After Validation, My table should look like this(similar to my names library).

Firstname	Last Name
John	Wood
Susan	Temple
John	Kent
Mike Dana	Brown
Terry	Rohr
Nelson	Little

I have already split the names into different columns like so:

data test;

   set data_in;

   length name1-name5 $10. surname1-surname5 $10. ;

   array name(5) $;

   array surname(5) $;

   do i = 1 to dim(name);

      name[i]=scan(STRIP(firstname),i,' &/','M');

       surname[i]=scan(lastname,i,' &/','M');

   end;

run;

Q My question is how do I begin to search for one name and multiple lastnames or one lastname and multiple names in the names library

[JosvanderVelden]

There are many ways. Have a look at the paper: https://support.sas.com/resources/papers/proceedings15/2219-2015.pdf