• Print |
• E-mail  |
• Bookmark

Calculations in a WHERE clause involving double-byte character set (DBMS) columns that are defined as datetime values can return incorrect results.

This problem occurs when a DBMS datetime column is listed in the SELECT clause and the column is aliased. The alias prevents the column's type from being identified as a datetime value in the operation.

This problem has occurred in left and right outer joins when the calculation is performed in a WHERE clause.

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

Operating System and Release Information

proc sql ;                                                  
  create table work.test as                                   
    select distinct                                             
           table0.name as name,                                     
           table1.dtime as dtime                                    
    from                                                        
        lib1.class1  table0                                      
           left join                                                   
         lib2.class2  table1                                      
         on (table0.name = table1.name and table0.age = table1.age)  
    where                                                       
     (table1.dtime - '11nov1969:12:28:00'dt = 120);           
quit;

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: