topic Re: proc dataset in SAS Programming

proc dataset

Steelers_In_DC — Thu, 16 Oct 2014 15:19:45 GMT

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

Re: proc dataset

Steelers_In_DC — Thu, 16 Oct 2014 15:41:33 GMT

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,

Re: proc dataset

ballardw — Thu, 16 Oct 2014 16:25:45 GMT

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;