topic Why the library does not exist in Servers interface SAS EG ? in SAS Programming

Why the library does not exist in Servers interface SAS EG ?

Phil_NZ — Mon, 01 Mar 2021 21:04:27 GMT

Hi all SAS Users,

Today when I import the library import into SAS Eg with the code below

libname import 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly;

I try to have a look about the file in this library from Serve interface but there is no display as below?

As you can see, no library import displayed.

Could you please tell me how to sort it out?

Warm regard!

Re: Why the library does not exist in Servers interface SAS EG ?

Reeza — Mon, 01 Mar 2021 21:06:12 GMT

What does the log show from that code?

Re: Why the library does not exist in Servers interface SAS EG ?

Phil_NZ — Mon, 01 Mar 2021 21:07:00 GMT

Hi @Reeza

The log is as below

28         options compress=yes reuse=yes;
29         options mergenoby=error;
30         OPTIONS MPRINT;
31         
32         libname import 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly;
NOTE: Libref IMPORT refers to the same physical library as ECI00004.
NOTE: Libref IMPORT was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: E:\Harv 27th_Feb_2021\global_daily_1999_2001
33         
34         
35         %LET _CLIENTTASKLABEL=;
36         %LET _CLIENTPROCESSFLOWNAME=;
37         %LET _CLIENTPROJECTPATH=;
38         %LET _CLIENTPROJECTPATHHOST=;
39         %LET _CLIENTPROJECTNAME=;
40         %LET _SASPROGRAMFILE=;
41         %LET _SASPROGRAMFILEHOST=;
42         
43         ;*';*";*/;quit;run;
44         ODS _ALL_ CLOSE;
45         
46         
47         QUIT; RUN;

Cheers.

Re: Why the library does not exist in Servers interface SAS EG ?

Reeza — Mon, 01 Mar 2021 21:10:34 GMT

So looks like it was assigned. See if PROC DATASETS shows you the items then, and see if the refresh button doesn't appear. Othewrise that's an issue you'll need to raise with tech support.

I would recommend using a different term than import as that's a key word in SAS and using those types of words in your code as names can cause unexpected issues.

libname myLib 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly;
proc datasets lib=myLib;
run;quit;

Re: Why the library does not exist in Servers interface SAS EG ?

Phil_NZ — Mon, 01 Mar 2021 21:14:53 GMT

Hi @Reeza

After running the code,the result is as below

Log

28         libname myLib 'E:\Harv 27th_Feb_2021\global_daily_1999_2001' access=readonly;
NOTE: Libref MYLIB refers to the same physical library as IMPORT.
NOTE: Libref MYLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: E:\Harv 27th_Feb_2021\global_daily_1999_2001
29         proc datasets lib=myLib;
30         run;

30       !     quit;

There is no "refresh" button appears clearly

So, it means I need to contact the tech support?

Warm regards.

Re: Why the library does not exist in Servers interface SAS EG ?

SASKiwi — Mon, 01 Mar 2021 21:37:33 GMT

@Phil_NZ - In the Servers window, if you right click on Libraries then you should get a Refresh option you can select.

Re: Why the library does not exist in Servers interface SAS EG ?

Phil_NZ — Mon, 01 Mar 2021 21:48:39 GMT

Hi @SASKiwi ,

Thank you for your help,

It is a new way of doing things that will benefit me. However, maybe because this file is quite big (128 GB with 11mil obs) so it cannot display over there still.

Warm regards

Re: Why the library does not exist in Servers interface SAS EG ?

SASKiwi — Mon, 01 Mar 2021 22:13:34 GMT

@Phil_NZ - Size shouldn't cause issues like library and and table names not showing. What version of EG are you using? The latest is 8.3 Update 1. If you aren't on this version then upgrading to it may be worth doing.