DATASETS Procedure

INDEX DELETE Statement

Deletes one or more indexes associated with the SAS data set specified in the MODIFY statement.
Restriction: Must appear in a MODIFY RUN group
Note: You can use the CONTENTS statement to produce a list of all indexes for a data set.

Syntax

INDEX DELETE index-1<...index-n> | _ALL_;

Required Arguments

index-1 <...index-n>
names one or more indexes to delete. The index(es) must be for variables in the SAS data set that is named in the preceding MODIFY statement. You can delete both simple and composite indexes.
_ALL_
deletes all indexes, except for indexes that are owned by an integrity constraint. When an index is created, it is marked as owned by the user, by an integrity constraint, or by both. If an index is owned by both a user and an integrity constraint, the index is not deleted until both an IC DELETE statement and an INDEX DELETE statement are processed.