Previous Page | Next Page

Optimizing Data Storage

Buffering Data for Base SAS Tables

For Base SAS tables, you might be able to make performance improvements by performing these tasks:

Besides specifying SAS system options on the command line or inside a SAS program with the OPTIONS statement, you can set the BUFSIZE= and BUFNO= system options in SAS Data Integration Studio. For example, you can set these System Options in the properties window for a table loader transformation.

[Table Loader Properties dialog box showing system options BUFNO=16 and BUFSIZE=4K]

For more information about the BUFSIZE= and BUFNO= options, see the SAS Language Reference: Dictionary and the documentation for your operating environment.

Note:   In addition, the SASFILE statement enables you to store the entire Base SAS table in memory, and the table remains open until you close it because SASFILE caches the data and the open request. For more information about the SASFILE statement, see the SAS Language Reference: Dictionary.  [cautionend]

Previous Page | Next Page | Top of Page