SAS maintains indexes for all changes to the table, whether the changes originate from PROC SQL or from some other source ... the index on it is also dropped. You can create simple or composite ...