SAS session hangs

PROC SQL has a WHERE clause containing the SUBSTR function as one of the conditions. There may be only one condition or multiple conditions.

When the SUBSTR function finds the second missing condition, the SAS session hangs.

This problem only affects the Scalable Performance Data Engine (SPDE) in Base SAS. It DOES NOT affect Base SAS data sets.

A hot fix is available for SAS 9.2 TS2M3 on specified hosts.

Operating System and Release Information

libname spdelib spde 'C:\temp\data1';

data spdelib.query;
  length emptyobs $30.;
    emptyobs="";
      output;
    emptyobs="";
      output;
run;

PROC SQL;
   SELECT *
     FROM spdelib.query AS test
     WHERE substr(test.emptyobs,4,-4) = "test"
     ;
QUIT;

A fix for this issue for Base SAS 9.21_M3 is available at: