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.
What is the result of a PROC DATSETS?
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.
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).
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 ...
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?
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 ...
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)
Look at views in ODS_LAG. Something is probably fishy there.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.