Providing software solutions since 1976
Training & Bookstore
The following error occurs when you run a PROC SQL query that uses the IDXNAME= data set option to specify the index name along with the WHERE= data set option to subset the table:
However, the process works correctly if you use these options in a DATA step.
To work around this problem, keep the IDXNAME= option in the query, as before, but use a WHERE clause instead of the WHERE= data set option.
Select the Hot Fix tab in this note to access the hot fix for this issue.
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: