Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - PROC Datasets and WHERE Expression

The video tutorial demonstrates how to use PROC DATASETS and PROC SQL to create simple and composite indexes in SAS datasets. It explains the advantages of indexing without prior knowledge of necessity, and guides through creating a simple index on a dataset, using the index in data operations, and finally creating a composite index with multiple variables. The tutorial emphasizes the importance of choosing a good discriminant variable for indexing and provides a resource for valid WHERE expressions to utilize the index effectively.

How can you check if a variable is a good discriminant variable for indexing?

What are the limitations of the where expression when using indexes in SAS?

What should you remember about the naming of a Composite Index?