Knowledge and Data Management White Papers
Crafting Your Own Index: Why, When, How
Overview A SAS index is a search file associated with a data file. Given a key, the file is searched and, if the key is found, its record ID is returned and used to retrieve the data file record. For many practical tasks, this works sufficiently fast. But fast is never fast enough - SAS indexes are disk-resident and so leave much room for acceleration. SAS auto-maintains its indexes, which is splendid. But oftentimes the trade-off is programmatic rigidity. When either overweighs the pain to program, the indexing scheme suddenly appears to virtually lend itself to custom crafting. Being no longer tied to a particular search algorithm or storage medium, one can let the programming fancy fly, the power of the SAS language being at disposal.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | February 2006 | Downloads | 1 |
| Format | White Papers | ||
| Topics | |||



