List out all tables and indexes and then recreate?

[WorkingMan]

Hi, I want to list out all BASE tables and indexes in a SAS library and then recreate using data set statement.

Normal data set without modify statement will wipe out the index option of the original table.

Assuming I have 30 tables in the library, how can i list out all table name and its index columns? I don't see that in dictionary table. If it is found in anywhere, i can assign it to a macro to perform the magic loop for all tables.

[Reeza]

SASHELP.VINDEX, which is probably dictionary.index, will show which indexes are applicable to your data sets. Or the PROC DATASETS output.

What's a "magic loop"?

---

@WorkingMan wrote:

Hi, I want to list out all BASE tables and indexes in a SAS library and then recreate using data set statement.

Normal data set without modify statement will wipe out the index option of the original table.

Assuming I have 30 tables in the library, how can i list out all table name and its index columns? I don't see that in dictionary table. If it is found in anywhere, i can assign it to a macro to perform the magic loop for all tables.

---

[ChrisNZ]

Why recreate the tables as is? Do you intend to change anything?

Also don't forget to set the sorted by  flag, if applicable, in your permanent tables.

[Ksharp]

Try this code,it could list info of WORK .Check "Use of Variable in Indexes".

data class(index=(x=(name sex)));set sashelp.class;run;
data class1;set sashelp.class;run;

proc contents data=work._all_ out=want noprint  ;
run;