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
Using an Index for WHERE Processing
Overview of Using an Index for WHERE Processing
WHERE processing conditionally selects observations for processing when you issue a
WHERE expression. Using an index to process a WHERE expression improves
performance and is referred to as optimizing the WHERE expression.
To process a WHERE expression, by default SAS decides whether to use an index or
read all the observations in the data file sequentially. To make this decision, SAS does
the following:
1. Identifies an available index or indexes.
2. Estimates the number of observations that would be qualified. If multiple indexes are
available, SAS selects the index ...
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