• Print |
• E-mail  |
• Bookmark

Using the IN operator in PROC SQL may produce incorrect results.  The
problem occurs in the later passes of code generation optimization.
For the problem to occur, the numerics being compared must be defined
with less than the default 8 bytes.

The following code illustrates the problem on OS/390.  The problem
exists on other systems, but may require differences in the code to
generate.

  data work.a;
   length code 3;
   input code;
  cards;
  1
  4
  ;
  proc sql;
    select code in (2,4)
    from work.a;
  quit;

The problem occurs in Versions 7 and 8, TSLEVELS P1 and M0
respectively, and Releases 8.1 and 8.2, TSLEVELS 1M0 and 2M0,
on all platforms.

A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#004576


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

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

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

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

Operating System and Release Information

A fix for Release 8.1 (TS1M0) for this issue is available at:

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

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