Problem Note 40209: SAS session using SPDE library hangs and does not finish
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
| 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;
| 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 |
