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

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	N/A	Solaris for x64	9.2 TS1M0	9.3 TS1M0
		OpenVMS on HP Integrity	9.2 TS1M0	9.3 TS1M0
		Linux for x64	9.2 TS1M0	9.3 TS1M0
		Linux	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled Solaris	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled HP-UX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled AIX	9.2 TS1M0	9.3 TS1M0
		Windows Vista for x64	9.2 TS1M0
		Windows Vista	9.2 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.2 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS1M0
		Microsoft Windows XP 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS1M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS1M0	9.3 TS1M0
		z/OS	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS1M0
		Microsoft® Windows® for x64	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP Professional	9.2 TS1M0	9.3 TS1M0
		HP-UX IPF	9.2 TS1M0	9.3 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

SAS code below replicates the problem. The PROC SQL does not return control back to SAS.

---

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:

http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#40209

---

Type:	Problem Note
Priority:	medium
Topic:	Data Management ==> Data Sources ==> SPDE (Scalable Performance Data Engine) SAS Reference ==> Functions ==> Character ==> SUBSTR (right of =)

Date Modified:	2010-08-06 12:54:49
Date Created:	2010-07-02 13:44:06