ERROR: Access Violation occurred during PREPARE!

tomcmacdonald — Mon, 18 Jun 2018 19:18:05 GMT

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


PROC FEDSQL;
	CREATE TABLE example (
		id VARCHAR(11)
	);
QUIT;

PROC FEDSQL;
	INSERT INTO example
	SELECT
		CASE LENGTH(id)
			WHEN 11 THEN SUBSTRING(id FROM 1 FOR 6) || SUBSTRING(id FROM 8 FOR 4)
			WHEN 12 THEN SUBSTRING(id FROM 1 FOR 6) || SUBSTRING(id FROM 8 FOR 5)
		END AS id
	FROM MYDATABASE.MYSCHEMA.MYTABLE
	WHERE regexp.match('/[0-9]+/', id) = 1 AND regexp.match('/[A-Z]+/', id) = 0;
QUIT;

Throws this error:

ERROR: Access Violation occurred during PREPARE!

What do I have to do to avoid this error?

Re: ERROR: Access Violation occurred during PREPARE!

SASKiwi — Fri, 22 Jun 2018 23:53:44 GMT

I note you've posted several times for the same subject. You would be better off opening a track to SAS Technical Support and report all of your DS2 access violation problems to them. They are in the best position to help.

topic Re: ERROR: Access Violation occurred during PREPARE! in SAS Programming

ERROR: Access Violation occurred during PREPARE!

Re: ERROR: Access Violation occurred during PREPARE!