Skip to Main Content
SAS 9.4 Language Reference, Second Edition
book

SAS 9.4 Language Reference, Second Edition

by SAS Institute
December 2013
Intermediate to advanced content levelIntermediate to advanced
824 pages
24h 21m
English
SAS Institute
Content preview from SAS 9.4 Language Reference, Second Edition
Factors that affect the comparison include the size of the subset relative to the size of the
data file, data file value order, data file page size, the number of allocated buffers, and
the cost to uncompress a compressed data file for a sequential read.
Note: If comparing resource costs results in a tie, SAS chooses the index.
Controlling WHERE Processing Index Usage with Data Set Options
You can control index usage for WHERE processing with the IDXWHERE= and
IDXNAME= data set options.
The IDXWHERE= data set option overrides the software's decision regarding whether to
use an index to satisfy the conditions of a WHERE expression as follows:
IDXWHERE=YES tells SAS to decide which index is the best for optimizing a
WHERE expression, disregarding ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

What's New in SAS 9.4

What's New in SAS 9.4

SAS Institute
Fiber Optic Cabling, 2nd Edition

Fiber Optic Cabling, 2nd Edition

Barry Elliott, Mike Gilmore

Publisher Resources

ISBN: 9781629590004