topic How to find strings that contain double spaces? in SAS Programming

How to find strings that contain double spaces?

somebody — Wed, 01 Jul 2020 01:04:36 GMT

I would like to find rows where the variable NAME has 2 or 3 consecutive spaces in the string. I used

find(name,'  ');

but it returns all rows. What am I doing wrong?

Re: How to find strings that contain double spaces?

SASKiwi — Wed, 01 Jul 2020 01:15:27 GMT

I suggest you try:

if name ne compbl(name);

Using FIND will locate trailing blanks on strings. SAS character variables are padded with trailing blanks if the text doesn't take up the full variable lengths.

Re: How to find strings that contain double spaces?

Ksharp — Thu, 02 Jul 2020 12:17:52 GMT

find( strip(name) ,'  ');