Errors occur in SAS Scalable Performance Data Server for numeric columns that are defined with the MISSING statement when it is used in WHERE processing.

For example, the errors that appear at the bottom of the following output are returned by the query for the WHERE condition that is specified for column VAR. Column VAR was defined using the MISSING statement.

   libname spds sasspds <...connection information ...>; 
   
   missing A;

   data spds.missing_A;
      input var;
      cards; 
   1
   1
   2
   A
   3
   A
   ; 
   run; 

   proc sql; 
      select distinct * from spds.missing_A where var=.a;
   quit; 
 
   SPDS_ERROR: Parse Failure:  select distinct MISSING_A.var from MISSING_A
               where MISSING_A.var is #.A;
   SPDS_ERROR: SQL passthru expression contained errors.

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: