topic Re: Proc Contents Full Library Description in SAS Programming

Proc Contents Full Library Description

DavidPhillips2 — Wed, 05 Feb 2020 18:25:26 GMT

Is there a way in Enterprise Guide to View the metadata of a Library? I'm to printout a list of tables in a library and then tables with column details. Then I will compare that list with that of a similar library on another server.

Re: Proc Contents Full Library Description

Astounding — Wed, 05 Feb 2020 18:37:50 GMT

If you are willing to write a program rather than point-and-click, you can use:

proc contents data=lib._all_;
run;

Re: Proc Contents Full Library Description

DavidPhillips2 — Wed, 05 Feb 2020 18:41:22 GMT

I ran into a lot of errors like:

ERROR: File schemaname.tablename1.DATA does not exist.

Do I need to do something before I can run:

proc contents data=lib._all_;
run;

Re: Proc Contents Full Library Description

Astounding — Wed, 05 Feb 2020 18:44:16 GMT

Are you working with SAS data sets?

Do you have a LIBNAME statement in the program to refer to the folder that contains those data sets?

Re: Proc Contents Full Library Description

DavidPhillips2 — Wed, 05 Feb 2020 18:45:54 GMT

libname demo meta library='Demo1';

proc contents data=demo. _all_;
run;

Re: Proc Contents Full Library Description

Tom — Wed, 05 Feb 2020 18:55:46 GMT

Assuming that you didn't actually include the space between the period and the _ALL_ then any errors you are getting is because of errors in the library that you connected to. You probably need to contact your local SAS administrator see why you are getting errors using that library.

Re: Proc Contents Full Library Description

data_null__ — Wed, 05 Feb 2020 20:51:04 GMT

@Tom wrote:

Assuming that you didn't actually include the space between the period and the _ALL_

The space does not cause syntax error.

35         proc contents data=work. _all_ noprint out=contents;
36            run;

NOTE: The data set WORK.CONTENTS has 47 observations and 41 variables.

Re: Proc Contents Full Library Description

SASKiwi — Wed, 05 Feb 2020 21:03:07 GMT

@DavidPhillips2 - I suspect that using PROC CONTENTS against a SAS library using the META engine will only work if the library has tables that are actually registered in SAS metadata - if it will work at all. There is also no guarantee that the registered table definition will match the actual table definition. So I guess it depends what you want to do here. Review the tables as stored on disk or how they are defined in SAS metadata.