topic Re: SASHELP.VTABLE Error: Libname doesn´t exist in SAS Programming

SASHELP.VTABLE Error: Libname doesn´t exist

FloHau — Fri, 01 Apr 2016 06:51:34 GMT

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.

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

LinusH — Fri, 01 Apr 2016 06:58:46 GMT

What is the result of a PROC DATSETS?

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

FloHau — Fri, 01 Apr 2016 07:06:49 GMT

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.

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

LinusH — Fri, 01 Apr 2016 07:44:20 GMT

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).

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

FloHau — Fri, 01 Apr 2016 08:03:31 GMT

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 ...

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

RW9 — Fri, 01 Apr 2016 08:19:48 GMT

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?

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

Kurt_Bremser — Fri, 01 Apr 2016 08:34:13 GMT

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 ...

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

FloHau — Fri, 01 Apr 2016 08:57:01 GMT

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)

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

Kurt_Bremser — Fri, 01 Apr 2016 08:42:50 GMT

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

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

RW9 — Fri, 01 Apr 2016 08:49:09 GMT

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.

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

LinusH — Fri, 01 Apr 2016 14:55:52 GMT

Could it be that any of the views are corrupt, or pointing to data sets not available at the moment?

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

Peter_C — Sat, 30 Apr 2016 21:35:44 GMT

Do views have a feature that might hide them