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: 673

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

Posted in reply to mohamed_zaki
proc sql;
select "Full Names",sum(COUNTW(name)>1) as N
from have
;
quit;
Super User
Posts: 5,424

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: 673

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,250

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,424

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
  • 492 views
  • 0 likes
  • 4 in conversation