Need help in creating regular expression for prxchange feed

yashpande — Sat, 24 Jun 2023 08:24:16 GMT

Hi,

I have below values in datset

Or
OR-
A OR B
AND+
and
Or-
ELSE
1ELSE

WHAT I want is out put as below

OR-
AND+
Or-
1ELSE

So Basically if there is any digit or expression just immediately after SAS reserved keywords then it should be selected and this needs to be done using Prxchange regular expression as then it would be feed off to another third-party tool hence a prxchange regex is must

I am completely out of ideas as I haven't used regex before

Any help is really appreciated

Re: Need help in creating regular expression for prxchange feed

Ksharp — Sat, 24 Jun 2023 10:05:30 GMT

data have;
input x $20.;
cards;
Or
OR-
A OR B
AND+
and
Or-
ELSE
1ELSE
;

data want;
 set have;
 want=prxchange('s/^[a-z]+$//i',-1,compress(x));
run;

topic Re: Need help in creating regular expression for prxchange feed in SAS Programming

Need help in creating regular expression for prxchange feed

Re: Need help in creating regular expression for prxchange feed