measuring efficiencies

SAS processing

controlling memory and I/O resources

creating and using an index 

Combining Data Horizontally

combining summary and detail data

using an index to combine data

updating data

combining summary and detail data using two SET statements (self-study)

appending raw data files

BY-Group Processing and Sorting

eliminating duplicates

sorting resources

choosing the right sort routine (self-study)

alternatives to sorting

using arrays as lookup tables 

using hash objects as lookup tables

using formats as lookup tables

transposing data to create a lookup table

compressing data files

creating a DATA step view

executing only necessary statements

eliminating unnecessary passes through the data

reading and writing only essential data

networking efficiency considerations (self-study)

Using the Scalable Performance Data Engine (Self-Study)

creating SPD engine tables

using the SPD engine efficiently

SPD Engine LIBNAME statement options list

Additional Topics (Self-Study)

modifying SAS data sets in place

creating generation data sets

creating integrity constraints

creating and using audit trails

working with Perl regular expressions

understand your operating system file structures and perform basic operating system tasks

understand programming logic concepts

understand the compilation and execution process of the DATA step

use different kinds of input to create SAS data sets from external files

use SAS software to access SAS data libraries

create and use SAS date values

read, concatenate, merge, match-merge, and interleave SAS data sets

use the DROP=, KEEP=, and RENAME= data set options

create multiple output data sets

use array processing and DO loops to process data iteratively

use SAS functions to perform data manipulation and transformations.