Estimating the Number of Observations
Overview
It is more efficient to use indexed
access for a small subset and to use sequential access for a large
subset. Therefore, after identifying any available indexes and evaluating
the conditions in the WHERE expression, SAS estimates the number of
observations that will be qualified by the index. Whether SAS uses
an index depends on the percentage of observations that are qualified
(the size of the subset relative to the size of the data set), as
shown below:
-
If the subset is less than 3% of the data set, direct access is almost certainly more efficient than sequential access, and SAS will use ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
