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
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| 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 | ||
A fix for this issue for Base SAS 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R19.html#56267A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#56267| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-08-05 11:00:32 |
| Date Created: | 2015-07-24 11:36:23 |