topic Re: List out all tables and indexes and then recreate? in SAS Programming

List out all tables and indexes and then recreate?

WorkingMan — Tue, 05 May 2020 04:01:40 GMT

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.

Re: List out all tables and indexes and then recreate?

Reeza — Tue, 05 May 2020 04:05:18 GMT

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.

Re: List out all tables and indexes and then recreate?

ChrisNZ — Tue, 05 May 2020 05:43:47 GMT

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.

Re: List out all tables and indexes and then recreate?

Ksharp — Tue, 05 May 2020 11:38:07 GMT

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;