Specifies a list of indexes to exclude when making WHERE expression evaluations.
Valid in: | DATA step and PROC step |
Default: | Blank |
Restriction: | Cannot be used with IDXWHERE=NO data set option |
Engine: | SPD Engine only |
a list of index names to exclude from the WHERE planner.
proc datasets lib=spde cen modify precs; index create stser=(state serialno) occind=(occup industry) hour89; quit;When evaluating the next query, the SPD Engine does not use the indexes for either the STATE or HOUR89 variables.
proc sql; create data set hr80spde as select state, age, sex, hour89, industry, occup from spde cen.precs (wherenoindex=(stser hour89)) where occup='022' and state in('37','03','06','36') and industry='012' and hour89 > 40; quit;