SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Check if name has first and last name

Reply
Super Contributor
Posts: 648

Check if name has first and last name

There is a column Customer name with first and last names together. not all the values have both first and/or last names. Want to know how many of them truly have both first and last names. They are separated by spaces.

 

Super Contributor
Posts: 490

Re: Check if name has first and last name

[ Edited ]

You can use COUNTW()

 

Example:

data want;
set have;
Fullname=(COUNTW(name)>1);
run;

 

Super Contributor
Posts: 490

Re: Check if name has first and last name

proc sql;
select "Full Names",sum(COUNTW(name)>1) as N
from have
;
quit;
Super User
Posts: 5,260

Re: Check if name has first and last name

"Truly" is a strong word. What locale do your names belong to?
Data never sleeps
Super Contributor
Posts: 648

Re: Check if name has first and last name

only way is to check the length before and after compressing the name. if they are equal then either names is missing,

Super User
Posts: 3,115

Re: Check if name has first and last name

You can count the words in a name but you can't accurately check if they have both first and last name.

 

For example is Bruce Roger two first names or a first name and a last name? Either of these names could be a first name or a last name.

 

Another: Van Hurst - is this a first name and a last name or a two word last name? 

Super User
Posts: 5,260

Re: Check if name has first and last name

Yes that's what I was getting at.
You need a data quality tool like data flux to manage this.
Data never sleeps
Ask a Question
Discussion stats
  • 6 replies
  • 470 views
  • 0 likes
  • 4 in conversation