36 %let SPDSWDEB=YES;

37         proc sql;
38               create table abc as select distinct rovat from
                         spdslib.test_compress
39                      where
40                              valid_from_dttm <= datetime() <= valid_to_dttm
41                      and     compress(rovat, "0123456789", "K")="32";


whinit: WHERE ((VALID_FROM_DTTM<=1.76356e+09) and (COMPRESS(ROVAT, '0123456789',
'K')='32') and (VALID_TO_DTTM>
=1.76356e+09))
whinit: wh-tree presented
                     /-NAME = [VALID_FROM_DTTM]
           /-CLE----|
          |          \-LITN = [1.76356e+09 DATETIME]
 --LAND---|
          |                    /-FUNC = [COMPRESS()]
          |          /-FLST---|
          |         |         |--NAME = [ROVAT]
          |         |         |--LITC = ['0123456789']
          |         |          \-LITC = ['K']
          |--CEQ----|
          |          \-LITC = ['32']
          |          /-NAME = [VALID_TO_DTTM]
           \-CGE----|
                     \-LITN = [1.76356e+09 DATETIME]
whinit: wh-tree after pruning
                     /-NAME = [VALID_FROM_DTTM]
           /-CLE----|
          |          \-LITN = [1.76356e+09 DATETIME]
 --LAND---|
          |          /-NAME = [VALID_TO_DTTM]
           \-CGE----|
                     \-LITN = [1.76356e+09 DATETIME]
whinit returns: SOME EVAL2

NOTE: Where clause requires SAS filtering support which could affect
performance. (See SPDSWDEB=YES for details.)