DATA Step, Macro, Functions and more

SASHELP.VTABLE Error: Libname doesn´t exist

Reply
New Contributor
Posts: 4

SASHELP.VTABLE Error: Libname doesn´t exist

[ Edited ]

Hello,

 

I´m trying to execute the following code:

PROC SQL; 
	CREATE TABLE WORK.TEST AS SELECT * FROM SASHELP.VTABLE;
QUIT;

The following errors occur: 

ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
ERROR: Library ABC doesn´t exist.
...

But the library ABC is defined correctly. It´s shown in the library list and I can query the tables in it. 

 

Do you have an idea how I can skip or solve this errors?

 

Thank you.

Super User
Posts: 5,424

Re: SASHELP.VTABLE Error: Libname doesn´t exist

What is the result of a PROC DATSETS?

Data never sleeps
New Contributor
Posts: 4

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Thank you for ur answer!

 

PROC DATASETS works fine. I execute the following code:

 

PROC DATASETS lib=ABC;
RUN;

The report shows all tables, names and paths correctly.

Super User
Posts: 5,424

Re: SASHELP.VTABLE Error: Libname doesn´t exist

obviously, there's something that is not working.

Please describe more about your library (engine, storage, authorization) ) and your environment (PC SAS, EG - metadata sever etc).

Data never sleeps
New Contributor
Posts: 4

Re: SASHELP.VTABLE Error: Libname doesn´t exist

thanks for your help.

 

I´m using SAS 9.3 and EG 4.3. The Libname is located on a local Disk (I:\...) and the engine says "V9".

In that Libname Folder are SAS Table and Index Files.

 

I tried to exclude the Libname from the query with > WHERE libname NE 'ABC' > but that doesn´t work.

 

Now, I find a solution that works but it doesn´t make sense in my opinion. The SAS Code works when I exclude alle entries where memtype NE 'VIEW' like this:

 

proc sql;
  create table test as
    select * from sashelp.vtable where memtype NE 'VIEW';
quit;

The strange this is that in that libname are only memtypes with the type "DATA", no views or something else. I don´t understand it ...

Super User
Super User
Posts: 7,942

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Does:

proc sql;
  create table TMP as select * from DICTIONARY.TABLES;
quit;

Work?  If not, can you export your sashelp.vtable to csv and post it?  Never come across this problem before, could it be that the library is assigned and then the underlying folder is deleted or something like, could there betwo entries in the?

Super User
Posts: 7,760

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Look at views in other libraries that reference a dataset in 'ABC', and then look closely at the library name in the view (special characters or such).

Just a hunch, but ...

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: SASHELP.VTABLE Error: Libname doesn´t exist

[ Edited ]
Posted in reply to KurtBremser

I tried to query the DICTIONARY.TABLES before. It results in exactly the same error.

 

Here is the csv (the relevant libname where the error occurs is ODS_LAG)

 

 

Super User
Posts: 7,760

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Look at views in ODS_LAG. Something is probably fishy there.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,942

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Yes, can't see anything there.  Do a filter on all sashelp - not just where the problem occurs - of all views.  Basically try to narrow down where the problem occurs - it maybe a special character in a file, it may be a connection to database etc.  So run a select on everything in sashelp.  Then exclude views, if that works we can look at just views, so retrestrict to that, narrow it down each run. 

Super User
Posts: 5,424

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Could it be that any of the views are corrupt, or pointing to data sets not available at the moment?
Data never sleeps
Valued Guide
Posts: 2,177

Re: SASHELP.VTABLE Error: Libname doesn´t exist

Do views have a feature that might hide them
Ask a Question
Discussion stats
  • 11 replies
  • 439 views
  • 0 likes
  • 5 in conversation