Query
|
Subset Size
|
---|---|
data _null_; set company.orders_large; where order_date='10JAN1998'd; run; |
2232 observations (out
of 19,033,380)< .02% of
the data set
|
Query
|
Subset Size
|
---|---|
data _null_; set company.orders_large; where order_date<'01JAN2000'd; run; |
12,752,365 observations
(out of 19,033,380) =approximately 67% of the data
set
|
Query
|
Subset Size
|
---|---|
data _null_; set company.orders_small; where order_date'30JUN1998'd; run; |
2 observations
(out of 140) =< 2 % of
the data set
|
Option
|
Action
|
---|---|
IDXWHERE=
|
specifies whether SAS
should use an index to process the WHERE expression, no matter which
access method SAS estimates is faster.
You cannot use IDXWHERE=
to override the use of an index for processing a BY statement.
|
IDXNAME=
|
causes SAS to use a
specific index.
|
proc print data=company.organization; where department='Sales'; run;
options msglevel=i; proc print data=company.organization (idxwhere=no); where department='Sales'; run;