topic Re: Remove only the second space from a string in SAS Programming

Remove only the second space from a string

tropical_surfer — Fri, 24 Jun 2016 19:43:40 GMT

How can I remove only the 2nd space in a string?

Astounding — Fri, 24 Jun 2016 21:40:39 GMT

There may be easier ways.

It may be that this is not what you really want. Remember, you are only shifting text over since the length of a character variable is fixed.

You may be better served by the COMPBL function.

WIth all that in mind, here is a way to approach what you asked for:

data want;

set have;

blanks=0;

if string > ' ' then do i=1 to length(string) until (blanks=2);

if substr(string, i, 1)=' ' then blanks + 1;

end;

if blanks=2 then string = substr(string, 1, i-1) || substr(string, i+1);

run;

I also tried looking at CALL SCAN, but didn't find an approach that seemed like it would work.

PGStats — Sat, 25 Jun 2016 03:27:41 GMT

Given the string

AsBsCssD

where s is a space, do you want

AsBCssD (second space of the string removed)

AsBsCsD (double space replaced by single space) ?

Patrick — Sat, 25 Jun 2016 04:36:08 GMT

What does "2nd space" mean? The 2nd occurence of a space or just don't have consecutive spaces?

For "not consecutive spaces" I'd use function "compbl()"

Ksharp — Sat, 25 Jun 2016 08:26:16 GMT

data _null_;
x='xxx yyy zzz';
call scan(x,3,p,l,' ');
want=substr(x,1,p-2)||substr(x,p);
put x= want=;
run;