Problem Note 43861: Views created by PROC RANK and PROC SORT with in-database processing are not deleted in SAS® 9.3
Views created in the Work library by PROC RANK and PROC SORT when using in-database processing are not deleted upon procedure termination. These views continue to accumulate with repeated PROC RANK and PROC SORT in-database submissions within the same SAS session. This degrades the performance of those procedures during the session.
To circumvent the problem, you can include a PROC DATASETS step following each PROC RANK
and PROC SORT step that is submitted to run with in-database processing. For example:
proc datasets library=work memtype=view nolist nowarn;
delete _ZSQL:;
run;
quit;
Operating System and Release Information
| SAS System | Base SAS | Solaris for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Linux | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| HP-UX IPF | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled HP-UX | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled AIX | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Windows Vista for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Z64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Linux for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Windows Vista | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Windows 7 Ultimate x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Ultimate 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Professional 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Home Premium x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Home Premium 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows XP Professional | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
| z/OS | 9.3 | 9.4 | 9.3 TS1M0 | 9.4 TS1M0 |
*
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.
Views created in the Work library by PROC RANK and PROC SORT when using in-database processing are not deleted upon procedure termination.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-08-02 13:46:59 |
| Date Created: | 2011-07-29 09:40:17 |
