11210 - Incorrect results occur when you use a WHERE= option with indexed tables in the SQL procedure

Problem Note 11210: Incorrect results occur when you use a WHERE= option with indexed tables in the SQL procedure

In PROC SQL, using the WHERE= data set option on tables that are indexed causes the WHERE= option to be ignored. Incorrect results are returned as a result. There is no indication that incorrect results are being returned.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	64-bit Enabled Solaris	8.2 TS2M0	9.1 TS1M0
		Solaris	8.2 TS2M0	9.1 TS1M0
		z/OS	8.2 TS2M0	9.1 TS1M0
		Microsoft Windows NT Workstation	8.2 TS2M0	8.2 TS2M0

* 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.

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

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

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#011210

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#011210

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

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

Type:	Problem Note
Priority:	high

Date Modified:	2004-03-12 09:38:11
Date Created:	2003-11-05 16:04:35

E-mail This Page

Knowledge Base

Problem Note 11210: Incorrect results occur when you use a WHERE= option with indexed tables in the SQL procedure

Operating System and Release Information

E-mail:
Password