• Print |
• E-mail  |
• Bookmark

Beginning in Version 8, a WHERE statement or data set option that
makes use of a user-written informat may produce incorrect results.
The problem occurs when an incorrect length is used internally to
apply the informat.  For example:

  DATA CNTLIN;
    FMTNAME='INFORMAT';
    START='0001111111';
    END='0001111111';
    LABEL='              1111111';
    TYPE='I';
  RUN;
  PROC FORMAT CNTLIN=CNTLIN;
  RUN;
  DATA A;
    X=2222222;
  RUN;
  DATA _NULL_;
    SET A (WHERE=(INPUT(PUT(X,Z10.),INFORMAT.) EQ 2222222)) ;
  RUN;

The WHERE in the last DATA step incorrectly returns zero observations.

To circumvent the problem, use a subsetting IF statement instead
of a WHERE.  This problem is corrected in SAS 9 TSLEVEL M0.


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

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

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#008919

Operating System and Release Information

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: