Problem Note 4536: PROC SQL UPDATE statement may use excessive CPU time
In Version 8, PROC SQL's UPDATE statement may use more CPU time than
in SAS Release 6.09E. The CPU increase may exceed 400%. In at least
one reported case, the problem has been identified as memory overwrite
problem.
To circumvent this problem, use the DATA step with the MODIFY and
REPLACE statements in place of PROC SQL and UPDATE.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#004536
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#004536
Operating System and Release Information
| SAS System | Base SAS | z/OS | 8.1 TS1M0 | 9 TS M0 |
*
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: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2002-05-17 15:09:20 |
| Date Created: | 2001-03-19 14:32:24 |
