An error message incorrectly appears when you submit a PROC SQL query that contains the following data set options:

• an IDXNAME= data set option that specifies an index name
• a WHERE= data set option that is used to subset the data

The following example illustrates an instance of using both the IDXNAME= and the WHERE= options in a PROC SQL query:

   options msglevel=i;
   
   data work.temp(index=(x));
      do x=1 to 10;
         output;
      end;
   run;
   
   data work.temp2;
      set work.temp(idxname=x where(x gt 4));
   run;

   proc sql;
      create table work.temp3 as
             select * from work.temp(idxname=x where=(x gt 4));
   quit;

The error message you receive is as follows:

This error does not occur when you use the same options in a DATA step. It also does not occur when you use the IDXNAME= data set option without the WHERE= data set option. The following example illustrates these two cases:

   options msglevel=i;
   
   data work.temp(index=(x));
      do x=1 to 10;
         output;
      end;
   run;
   
   data work.temp2;
      set work.temp(idxname=x where(x gt 4));
   run;
   
   proc sql;
      create table work.temp3 as 
             select * from work.temp(idxname=x);
   quit;

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

Operating System and Release Information

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: