PROC SQL;
create <unique> index <indexname> on <tablename(colname)>; *unique 可选
quit;
示例:
PROC SQL;
create unique index studentID on class(studentID);
quit;
复合索引示例:
PROC SQL ;
create index IDNAME on class(studentID,firtname);
quit;
删除用DROP:
PROC SQL;
drop index studentID from class;
quit;