SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14745: Out of memory when using LIKE statement in WHERE clause with large data sets on SAS 9.1.3 DBCS

DetailsHotfixAboutRate It
When you use a LIKE statement in a WHERE clause with large data sets
on DBCS versions of SAS 9.1.3, the following note appears:

   NOTE: The SAS System stopped processing this step because of errors.
   NOTE: There were 1 observations read from the data set BHV2.URI0412.
   WHERE (UR_5C='0') and ((UR_19D='500978600') or UR_29D like '6003_' or
   UR_29D like '4112_' or UR_29D like '4011_');
   WARNING: The data set WORK.QURY3840 may be incomplete. When this step
            was stopped there were 0 observations and 9 variables.
   NOTE: PROCEDURE SQL used (Total process time):

This message appears when virtual memory usage ("commit charge" in Task
Manager) exceeds about 2 GB.

For the workaround, you can use the SUBSTR statement or a regular
expression in the WHERE clause instead of the LIKE statement.

A fix for SAS 9.1.3 (9.1 TS1M3) (with Asian Language Support) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014745


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft Windows XP Professional9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Standard Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Server9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Professional9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Advanced Server9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Datacenter Server9.1 TS1M39.1 TS1M3 SP3
Linux9.1 TS1M39.1 TS1M3 SP3
64-bit Enabled Solaris9.1 TS1M39.1 TS1M3 SP3
z/OS9.1 TS1M39.1 TS1M3 SP3
Linux on Itanium9.1 TS1M39.1 TS1M3 SP3
64-bit Enabled AIX9.1 TS1M39.1 TS1M3 SP3
HP-UX IPF9.1 TS1M39.1 TS1M3 SP3
64-bit Enabled HP-UX9.1 TS1M39.1 TS1M3 SP3
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP3
* 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.