Chapter Contents |
Previous |
Next |
SAS/ACCESS Interface to CA-DATACOM/DB: Reference |
The SAS BY statement issues an ordering clause to CA-DATACOM/DB so that CA-DATACOM/DB does the sorting using its system resources. This SORT clause overrides any existing SORT clause for the view descriptor. If you decide to use a SORT clause or a SAS BY statement, order by a key, which is indexed, when possible. (For help in determining which fields in a table are indexed, see your DBA or the table's creator.)
As an alternative to using a SORT clause, which consumes CPU time each time you access the CA-DATACOM/DB table, you could use the SORT procedure with the OUT= option to create a sorted SAS data file. This is a better approach for data you want to use many times.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.