06-18-2018 01:48 PM - edited 06-18-2018 01:48 PM
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?