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

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

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