04-01-2016 02:48 AM - edited 04-01-2016 02:51 AM
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?
04-01-2016 03:06 AM
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.
04-01-2016 03:44 AM
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).
04-01-2016 04:03 AM
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 ...
04-01-2016 04:19 AM
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?
04-01-2016 04:34 AM
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 ...
04-01-2016 04:36 AM - edited 04-01-2016 04:57 AM
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)
04-01-2016 04:42 AM
Look at views in ODS_LAG. Something is probably fishy there.
04-01-2016 04:49 AM
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.