Prxchange Prxmatch

SASPhile — Tue, 29 Jan 2019 22:01:43 GMT

I tried below code to convert the words to space if the string ends in limited,ltd,plc,sa,inc. But the third record(limited abc) , the abc is converted to a space. Any help is appreciated!

data test;

input string $1-12;

cards;

abc limited

pqr ltd

limited abc

abc sa

abc plc

plc abc

abc inc

;

run;

data want;

set Test;

if prxmatch("/(^.*\binc\b|^.*\blimited\b|^.*\bltd\b|^.*\bsa\b|^.*\bplc\b)/i",string) > 0 then do;

want=prxchange('s/\w+$//',-1,strip(string));

End;

run;

Re: Prxchange Prxmatch

PGStats — Tue, 29 Jan 2019 23:07:52 GMT

Keep it simple:

data have;
input string $12.;
cards;
abc limited
pqr ltd
limited abc
abc sa
abc plc 
plc abc
abc inc
;

data want;
 set have;
 want = prxchange("s/\s*\b(inc|limited|ltd|sa|plc)\s*$//io", 1, string);
run;

topic Prxchange Prxmatch in New SAS User

Prxchange Prxmatch

Re: Prxchange Prxmatch