Is there a lib window and a fileref like in DM? I'm new to EG and its 4.1. I wrote a sql dictionary statement to find the librefs for the code I've inherited but think there should be a button somewhere...
Because the window has a zillion little filedrawers in the window I didn't see that there was some yellow ones that are my active libs and my friend Thomas texted me from afar that I MUST refresh with the right click.
Is there sas code to write to find the active filerefs?
Thanks for the code, it didn’t quite work on my system.
15 create table currentFiles as
16 select fileref,
17 xpath, modate,
19 from dictionary.extfiles
20 where substr(fileref,1,1) ne "#";
ERROR: The following columns were not found in the contributing tables: directory, modate.
This is what worked:
create table currentFiles as
where substr(fileref,1,1) ne "#";
I meant the library displayed on the top of library portion of the Server list. You can access the Server List by selecting View -> Server. Then double click on Servers, then of the server which you use, then on Libraries, and you will see this library list.