• Print |
• E-mail  |
• Bookmark

If you use the WHERE EXPRESSION window within the VIEWTABLE window and
chose "<Lookup distinct values>" to build a WHERE clause on a column
with several thousand distinct values, it may take more than a minute to
subsequently close the VIEWTABLE window.

There are 2 possible circumventions for this performance problem:

   1. within the WHERE EXPRESSION window, use <enter Constant value>
      rather than <Lookup distinct values> to define the value upon
      which to create the subset

   2. avoid the WHERE window altogether and issue the WHERE command.


A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#013657


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013657

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

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

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

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