topic Re: Replace more than one space with ^n in SAS Programming

Replace more than one space with ^n

SASdevAnneMarie — Thu, 04 Jun 2020 08:39:38 GMT

Hello,

I'm trying to replace more than one space by ^n,

But my code doesn't work:

data OBJ1;

set OBJ2;

rx = prxparse('s/(\w+ \w*) +.*/^n/');
call prxchange(rx,-1,OBJECTIVES);

run;

Do you know please some options to replace more than two spaces?

Thank you for your help!

Best regards,

Marie

Re: Replace more than one space with ^n

Jagadishkatam — Thu, 04 Jun 2020 08:51:30 GMT

Please try the below code , in the example below in objectives variable we have sample1 followed by two spaces number 2 and then number 3 with one space and it replaced only the two spaces between 1 and 2 with ^n

data OBJ1;
OBJECTIVES='sample1  2 3 4  5  6';
new=prxchange('s/\b\s{2,}\b/^n/oi',-1,OBJECTIVES);
run;

Re: Replace more than one space with ^n

yabwon — Thu, 04 Jun 2020 09:22:38 GMT

Small update if I may, to cover leading and trailing spaces:

data OBJ1;
  OBJECTIVES='   sample1  2 3 4    5          6   ';
  new=prxchange('s/(^|\b)\s{2,}(\b|$)/^n/oi',-1,OBJECTIVES);
  put _all_;
run;

Bart

Re: Replace more than one space with ^n

smantha — Thu, 04 Jun 2020 15:20:26 GMT

What happened to plain old cmpbl (compressible function).

Re: Replace more than one space with ^n

SASdevAnneMarie — Thu, 04 Jun 2020 15:45:30 GMT

Thank you!