How do you write a wrapper for PRXMATCH for FEDSQL?

tomcmacdonald — Mon, 18 Jun 2018 17:48:56 GMT

I can't get past this seemingly trivial exercise. I would like to take advantage of all that PROC FEDSQL has to offer but simply cannot get consistent use of a PROC DS2 package.

PROC DS2;
	package regexp / overwrite=yes;
		method match( varchar(1024) pattern, varchar(1024) string ) returns integer;
			return prxmatch(pattern, string);
		end;
	run;
QUIT;

Seems to yield the cryptic and not very useful error message of

ERROR: Access Violation occurred during PREPARE!

When trying to use it here for instance

PROC FEDSQL;
	INSERT INTO tableB
	SELECT id 
	FROM tableA
	WHERE 
		regexp.match('/.*/', id) = 1 
		AND regexp.match('/^[5-9]/', id) = 0;
QUIT;

Like are these PROC DS2 packages simply broken when used with PROC FEDSQL and I should just wait until 9.5 to come out when SAS has hopefully fixed all the bugs? Is this thing just inherently buggy?

Re: How do you write a wrapper for PRXMATCH for FEDSQL?

tomcmacdonald — Mon, 18 Jun 2018 18:54:30 GMT

Anyone? Would truly love to use this feature but cannot unless I have full PRXMATCH functionality.

topic Re: How do you write a wrapper for PRXMATCH for FEDSQL? in SAS Programming

How do you write a wrapper for PRXMATCH for FEDSQL?

Re: How do you write a wrapper for PRXMATCH for FEDSQL?