SAS Component Language Dictionary |
Category: | SAS Table |
Syntax | |
Details | |
Example | |
See Also |
Syntax |
index=ISINDEX(table-id,col-name); |
is the identifier that was assigned when the table was opened. If table-id is invalid, the program halts.
is the name of a column in the SAS table. If col-name is not a column in the table, then ISINDEX returns a blank value.
Details |
An index is an auxiliary data structure used to assist in the location (that is, selection) of rows that are specified by the value of a column. An index is called a simple index if it contains the value of only one column. A composite index merges the values for more than one column to form a single value. A given SAS table can have multiple simple indexes, composite indexes, or any combination of these.
Example |
Return the type of index for the FNAME column in the SAS table WORK.DATAONE:
dsid=open('work.dataone','i'); ixtype=isindex(dsid,'fname');
See Also |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.