How do you use regular expressions with PROC FEDSQL?

tomcmacdonald — Fri, 15 Jun 2018 19:40:02 GMT

The SAS function PRXMATCH does not work. How can I get regular expression functionality with PROC FEDSQL?

Re: How do you use regular expressions with PROC FEDSQL?

s_lassen — Mon, 18 Jun 2018 10:57:43 GMT

It seems you can use functions from DS2 packages in FEDSQL. So something like this may be a workaround:

/*  DS2 code */
proc ds2;
   package prxfunc;
      method match(char prx, char source) returns integer;
         return prxmatch(prx,source);
      end;
   endpackage;
 run;
quit;

/* fedsql code */
proc fedsql;
   select * from mytable
      where prxfunc.match('/Joe/',firstname);
quit;

topic Re: How do you use regular expressions with PROC FEDSQL? in SAS Programming

How do you use regular expressions with PROC FEDSQL?

Re: How do you use regular expressions with PROC FEDSQL?