topic Re: regex in SAS in SAS Data Management

regex in SAS

aaaaa34 — Wed, 04 Dec 2019 15:43:52 GMT

Hi,

How can I delete "qt" in 0,023qt using regex?

Re: regex in SAS

PeterClemmensen — Wed, 04 Dec 2019 15:47:58 GMT

data test;
   string="0,023qt";
   newstring=prxchange('s/qt//', -1, string);
run;

Re: regex in SAS

aaaaa34 — Wed, 04 Dec 2019 15:54:27 GMT

Is it possible to use PRXPARSE? I'd like to use it in my code.

Re: regex in SAS

PeterClemmensen — Wed, 04 Dec 2019 15:57:39 GMT

The PRXPARSE Function simply compiles the rexex for later use. Sure you can use it, but you don't really benefit from it, since PRXCHANGE accepts an actual regular expression and not only the compiled rexex id

data test;
   string="0,023qt";
   rx=prxparse('s/qt//');
   newstring=prxchange(rx, -1, string);
run;