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
Improving Performance of WHERE Processing
Indexing a SAS data set can significantly improve the performance of WHERE
processing. An index is an optional file that you can create for SAS data files in order to
provide direct access to specific observations.
Processing a WHERE expression without an index requires SAS to sequentially read
observations in order to find the ones that match the selection criteria. Without an index,
SAS first checks for the sort indicator, which is stored with the data file from a previous
SORT procedure or SORTEDBY= data set option. If the sort indicator is validated, SAS
takes advantage of it and stops reading the ...
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