proc dataset

[Steelers_In_DC]

I'd like to run a proc datasets lib=XXXX;contents data=_all_;quit;run; but one of the tables is corrupted so it will fail.  I do not want to delete the bad table to get this information.  Is there a way to get this information without going through each table 1 by 1?

Thanks in advance,

Mark

[Steelers_In_DC]

I ended up getting the data from proc datasets lib=xxxx:quit;run;

then putting that into

proc datasets lib=xxxx nolist;contents data= ____;quit;run

using excel's concatenate to list the 400 table names, copy pasted it into SAS, if there are any other options let me know.

Cheers,

[ballardw · Accepted solution]

Another place to look at the information about SAS tables in variables are the DICTIONARY tables available for use in proc sql or the views in SASUSER. I don't know if this has a problem with a corrupted dataset as I don't have one to test with at the moment.

Proc sql;

     create table libcontents as

     select Memname

     from dictionary.members

     where libname='LIBRARY';

quit;

use

Proc SQL;

     describe table dictionary.columns ;/* for variable info or  dictionary.members for dataset info*/

quit;