General form, PROC SQL
to create and delete an index:
PROC SQL;
CREATE <UNIQUE > INDEX index-name
ON table-name(column-name-1<...,column-name-n>);
DROP
INDEX index-name FROM table-name;
QUIT;
index-name
is the same as column-name-1 if
the index is based on the values of one column only.
index-name
is not the same as
any column-name if the index
is based on multiple columns.
table-name
is the name of the
data set that index-name is
associated with.
|
proc sql; create index origin on sasuser.sale2000(origin); quit;
proc sql; drop index origin from sasuser.sale2000; create index Tofrom on sasuser.sale2000(origin, dest); quit;
18.189.178.237