BeOptimized - SAS Publications

SAS Macro Program Data Vector SQL Optimization Hash Object Parallel Processing Indexes Log Analysis SAS Optimization DS2 ODS SAS Arrays DO LOOPS

Publications about SAS Optimization

Programming Tricks For Reducing Storage And Work Space

This paper discusses couple of interesting options to reduce data set disk storage (compress, reuse options..)

Off and Running with Arrays in SAS

Whenever there are a group of variables to be processed in the data step, it might be well worth considering using arrays to help accomplish the business objective. This paper shows you how to use SAS Arrays

So You're Running Out of Sort Work Space . . .Reducing the Resources Used by PROC SORT

The SAS software contains tools and strategies that reduce or trade off the resources needed to sort data. This tutorial explains these tools, with an emphasis on reducing the amount of sort work space.

Table Lookup: Techniques Beyond the Obvious

This paper discusses seven different approaches to perform the table lookup in terms of processing time and the complexity of coding.

Using KEY= to Perform Table Look-up

This paper demonstrates the use of indexes to perform table look-up in SAS DATA Step

Table Look-up Using Techniques Other Than the Matched Merge DATA Step

Table Look-up comparison with Indexes, SQL, Arrays, and Formats.

Table Lookup in SAS

Table Look-up comparison with proc sql, merge, arrays, formats, hash, SET Key=