Problem Note 56267: PROC SQL joins terminate due to excessive memory usage when the join condition uses the LIKE operator
An SQL procedure join that specifies the LIKE operator might terminate unexpectedly. No error message is shown, but you might see a warning similar to this:
WARNING: The data set WORK.ONE may be incomplete.
When this step was stopped there were 0 observations and 14 variables.
WARNING: Data set WORK.ONE was not replaced because this step was stopped.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Solaris for x64 | 9.2 TS2M3 | 9.4 TS1M3 |
OpenVMS on HP Integrity | 9.2 TS2M3 | 9.4 TS1M3 |
Linux for x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Linux | 9.2 TS2M3 | 9.4 TS1M3 |
HP-UX IPF | 9.2 TS2M3 | 9.4 TS1M3 |
64-bit Enabled Solaris | 9.2 TS2M3 | 9.4 TS1M3 |
64-bit Enabled HP-UX | 9.2 TS2M3 | 9.4 TS1M3 |
64-bit Enabled AIX | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Ultimate 32 bit | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Enterprise 32 bit | 9.2 TS2M3 | 9.4 TS1M3 |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Microsoft Windows Server 2008 | 9.2 TS2M3 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Professional x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Professional 32 bit | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Home Premium x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Home Premium 32 bit | 9.2 TS2M3 | 9.4 TS1M3 |
Windows 7 Enterprise x64 | 9.2 TS2M3 | 9.4 TS1M3 |
Microsoft Windows Server 2008 R2 | 9.2 TS2M3 | 9.4 TS1M3 |
z/OS | 9.2 TS2M3 | 9.4 TS1M3 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2015-08-05 11:00:32 |
Date Created: | 2015-07-24 11:36:23 |