topic Libraries not appearing in the tree explorer despite being assigned EG7.1 in SAS Enterprise Guide

Libraries not appearing in the tree explorer despite being assigned EG7.1

Kelvin_Y — Tue, 07 Aug 2018 14:15:37 GMT

I have successfully assigned libraries and I can run a query against it but the libraries do not appear in the explorer. This includes the default libraries such as work and sashelp.

Anyone know how to get these to reappear?

Re: Libraries not appearing in the tree explorer despite being assigned EG7.1

CaseySmith — Tue, 07 Aug 2018 15:19:52 GMT

If no libraries are appearing in EG's Server list, then the most likely explanation is that your OBS= system option is set to 0. Thus, the query EG uses to retrieve the libraries returns no results -- can't populate the Servers list.

You can confirm this by submitting the code below and inspect the OBS= value in the log:

proc options option=obs;

run;

The most likely reason your OBS= system option is set to 0 is because your server has the SYNTAXCHECK system option turned on and an error was encountered running DATA step code in the server session. In which case, either turn off syntax check mode (NOSYNTAXCHECK) or figure out why the ERROR is occurring and avoid it.

See this paper for details on SAS' Syntax Check mode:

http://support.sas.com/resources/papers/proceedings13/327-2013.pdf

Casey

Re: Libraries not appearing in the tree explorer despite being assigned EG7.1

AltadenaCheetah — Wed, 17 Jul 2019 21:21:39 GMT

Were you able to correct the issue you were having? I am having the same issue. My OBS option was not set to zero, but was a very large number. Any assistance would be appreciated.

Re: Libraries not appearing in the tree explorer despite being assigned EG7.1

SASKiwi — Thu, 18 Jul 2019 08:25:49 GMT

Have you always had this problem since you started using EG or was it working previously? Is it all libraries or just some? Another explanation is that you do not have read metadata permissions set on these libraries. This is something your SAS administrator will need to fix for you.

Re: Libraries not appearing in the tree explorer despite being assigned EG7.1

AltadenaCheetah — Thu, 18 Jul 2019 21:34:51 GMT

I think it is a corrupt SAS EG project that is causing the problems. Not sure how to fix it other than to start a new project and set it up the same way. Kind of a pain, but not too bad, I guess.