DATA Step, Macro, Functions and more

How do you write a wrapper for PRXMATCH for FEDSQL?

Reply
Frequent Contributor
Posts: 101

How do you write a wrapper for PRXMATCH for FEDSQL?

[ Edited ]

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?

 

 

 

Frequent Contributor
Posts: 101

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

Posted in reply to tomcmacdonald

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

Ask a Question
Discussion stats
  • 1 reply
  • 52 views
  • 0 likes
  • 1 in conversation