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   ... View more