Name Validation

oolugboji — Wed, 18 Sep 2019 16:39:35 GMT

*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

Re: Name Validation

JosvanderVelden — Wed, 18 Sep 2019 17:11:10 GMT

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

topic Name Validation in New SAS User

Name Validation

Re: Name Validation