- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-26-2010 09:22 PM
(9615 views)
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...
8 REPLIES 8
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You can use Tools->SAS Enterprise Guide Explorer to see the active libraries. Unfortunately it's a "modal" window, which means you can't interact with EG while this window is displayed.
You can also use View->SAS Servers and expand the server list and library list, but you'll need to Refresh it whenever you make a change that you want to see reflected.
There isn't a built-in window to show active filerefs.
Chris
You can also use View->SAS Servers and expand the server list and library list, but you'll need to Refresh it whenever you make a change that you want to see reflected.
There isn't a built-in window to show active filerefs.
Chris
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
OK Thanks Chris,
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?
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Here's one example of getting a list of active filerefs. The WHERE clause filters out the system-generated filerefs you might not care to see.
[pre]
proc sql;
create table currentFiles as
select fileref, xpath, modate, directory from dictionary.extfiles
where substr(fileref,1,1) ne "#";
quit;
[/pre]
Chris
[pre]
proc sql;
create table currentFiles as
select fileref, xpath, modate, directory from dictionary.extfiles
where substr(fileref,1,1) ne "#";
quit;
[/pre]
Chris
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Chris:
Thanks for the code, it didn’t quite work on my system.
proc sql;
15 create table currentFiles as
16 select fileref,
17 xpath, modate,
18 directory
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:
proc sql;
create table currentFiles as
select *
from dictionary.extfiles
where substr(fileref,1,1) ne "#";
quit;
Thanks for the code, it didn’t quite work on my system.
proc sql;
15 create table currentFiles as
16 select fileref,
17 xpath, modate,
18 directory
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:
proc sql;
create table currentFiles as
select *
from dictionary.extfiles
where substr(fileref,1,1) ne "#";
quit;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello WhiteSalmon,
From my experience with EG, it is a good idea to have an underscore as a first character of a user library name. In this case this library is always displayed on the top of the library list.
Sincerely,
SPR
From my experience with EG, it is a good idea to have an underscore as a first character of a user library name. In this case this library is always displayed on the top of the library list.
Sincerely,
SPR
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for that SPR:
I tried that tip and used this code to review but it didn't seem to land my _mylib
on top of that list :
title "Current Libraries";
proc sql;
select distinct(libname)
from sashelp.vlibnam;
quit;
I tried that tip and used this code to review but it didn't seem to land my _mylib
on top of that list :
title "Current Libraries";
proc sql;
select distinct(libname)
from sashelp.vlibnam;
quit;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Bingo!
I see ! I see! I see those librefs!
Great idea! It helps those of us going blind from squinting at this stuff...
I see ! I see! I see those librefs!
Great idea! It helps those of us going blind from squinting at this stuff...