DATA Step, Macro, Functions and more

ERROR: Access Violation occurred during PREPARE!

Reply
Frequent Contributor
Posts: 101

ERROR: Access Violation occurred during PREPARE!

[ Edited ]

 

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? 

 

Super User
Posts: 3,926

Re: ERROR: Access Violation occurred during PREPARE!

Posted in reply to tomcmacdonald

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.

Ask a Question
Discussion stats
  • 1 reply
  • 80 views
  • 1 like
  • 2 in conversation