Problem Note 14745: Out of memory when using LIKE statement in WHERE clause with large data
sets on SAS 9.1.3 DBCS
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
SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
z/OS | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Linux on Itanium | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
Tru64 UNIX | 9.1 TS1M3 | 9.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.
Type: | Problem Note |
Priority: | high |
Topic: | System Administration ==> Installation ==> NLS (National Language Support)
|
Date Modified: | 2005-04-08 09:09:46 |
Date Created: | 2005-03-09 15:30:18 |