topic Re: ERROR: Library does not exist in New SAS User

ERROR: Library does not exist

chelly — Thu, 28 Mar 2019 15:56:21 GMT

We are running MXG36.36 with SAS9.4 on Windows 10 x64 bit. (Testing phase - not a live one yet)

When I try to run a proc content command I keep getting Library xxxxxx Does not exist.

Physically the file is present and I have also assigned them in my autoexec file.

When I execute

proc contents data=detail.typetcp; ----> this is a SQL VIEW

run;

ERROR: Library D31JAN19 does not exist. ----> I get almost 90 errors with different dates starting from Dec 2018

where as when I run the following

proc contents data=D31JAN19._all_ nods;

run;

I get the output

Only this Procedure Content is causing trouble, all other proc's are running fine.

Background : We also use SAS 9.2 on Windows 7 32bit and the same code works fine.

Thanks for you help.

Re: ERROR: Library does not exist

ballardw — Thu, 28 Mar 2019 16:14:46 GMT

Where is the LIBNAME statement that assigns your library named D31JAN19.

Or is D31JAN19 supposed to be a data set in the DETAIL library? If so the syntax would use the library name with the data set:

proc contents data=detail.D31JAN19;
run;

If you looking to run contents on a library the library has to be defined first and the only library I see that may be defined other than the WORK and SAS supplied SASHELP and SASUSER is DETAIL.

If you want all of the data sets in the DETAIL library the syntax would be

proc contents data=detail._all_
run;

Re: ERROR: Library does not exist

chelly — Thu, 28 Mar 2019 16:23:50 GMT

LIBANAME statement is coded in my autoexec file

LIBNAME GDG         'd:\SASDATA\GDG';
LIBNAME EMPTY    'd:\SASDATA\EMPTY';
LIBNAME HISTORY     'd:\SASDATA\HISTORY';
LIBNAME D01JAN19    'd:\SASDATA\GDG\D01JAN19';
LIBNAME D02JAN19    'd:\SASDATA\GDG\D02JAN19';

etc...

When I run the following

proc sql;

describe view DETAIL.TYPETCPA;

I get

SQL view is defined as follows

select *

from D01FEB19.TYPETCPA

union all corresponding

select *

from D01JAN19.TYPETCPA

union all corresponding

select *

from D01MAR19.TYPETCPA

union all corresponding

select *

from D02FEB19.TYPETCPA

union all corresponding

select *

from D02JAN19.TYPETCPA

union all corresponding

select *

;

etc...…..

Re: ERROR: Library does not exist

ballardw — Thu, 28 Mar 2019 17:34:56 GMT

Since the issue is with the D31JAN19 it would be appropriate to actually show the libname statement for that library.

Clear the log.

Run your autoexec manually.

Paste the log into a code box opened using the forum's {I} icon.