SAS Component Language Dictionary

IDELETE

Deletes an index from a SAS table

Category:

SAS Table

Syntax

sysrc=IDELETE(table-id,key-name);

sysrc

contains the return code for the operation:

0	successful
0	not successful

Type: Numeric

table-id

is the identifier that was assigned when the table was opened. If table-id is invalid, the program halts.

Type: Numeric

key-name

is the name of the index key to be deleted.

Type: Character

In order to delete an index for a SAS table, you must open the table in UTILITY mode (see OPEN for details).

You can also delete indexes using

Delete an index for the SAS table WORK.INVOICE. The name of the index key is ITEMTYPE.

tableid=open('work.invoice','v');
rc=idelete(tableid,'itemtype');