Problem Note 4466: PROC SQL query with SELECT DISTINCT may return incorrect results on
VMS
PROC SQL implements DISTINCT by sorting the table then deleting
duplicate rows. Depending on the size of the intermediate table, the
host sort routine may be called when the system option SORTPGM=BEST is
specified. The host sort routine is always called when SORTPGM=HOST
is in effect.
There is a problem on both VAX and OpenVMS when the host sort is
called whereby only one row is returned.
To circumvent this problem, specify SORTPGM=SAS before running PROC
SQL.
A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#004466
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#004466
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#004466
Operating System and Release Information
| SAS System | Base SAS | OpenVMS VAX | 8.1 TS1M0 | |
| OpenVMS Alpha | 8.1 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.
| Type: | Problem Note |
| Priority: | alert |
| Topic: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2002-04-23 16:36:54 |
| Date Created: | 2001-03-09 12:06:00 |
