topic Re: I cannot find the library I created in Enterprise Guide in SAS Enterprise Guide

I cannot find the library I created in Enterprise Guide

Shiauyin — Sun, 25 Sep 2022 22:35:03 GMT

Hi,

I am using Enterprise Guide (8.3) and following the course SAS programming 1 to create a library. The library NP was created successfully (according to the log) but I cannot see it on the local libraries list. Anyone where to find the library I created and why it's not in the local libraries list? ?

Re: I cannot find the library I created in Enterprise Guide

Kurt_Bremser — Mon, 26 Sep 2022 01:00:10 GMT

Which path do you get when you right-click WORK and select Properties?

Re: I cannot find the library I created in Enterprise Guide

Shiauyin — Mon, 26 Sep 2022 02:25:18 GMT

C:\Users\yinyi\AppData\Roaming\SAS\EnterpriseGuide\EGTEMP\SEG-5936-d45e8d98\contents\SAS Temporary Files\_TD12648_DESKTOP-IBUTM48_\Prc2

Re: I cannot find the library I created in Enterprise Guide

Kurt_Bremser — Mon, 26 Sep 2022 03:12:23 GMT

So you try to access an Excel file in your physical WORK directory. How did you store it there?

Note: if you copied the file to the WORK location in a previous SAS session, it's gone now, as the WORK directory is removed at the end of the session, and a new one created when a new session initiates.

Re: I cannot find the library I created in Enterprise Guide

Shiauyin — Mon, 26 Sep 2022 03:39:37 GMT

Hi Kurt,

I was just trying to follow the activity in the programming 1 (lesson 2).

Perform the following tasks in your SAS software:

Open a new program window.
Write a LIBNAME statement to create a library named NP that reads np_info.xlsx in the course data as follows:
- SAS Studio: Specify the full path to your EPG1V2/data folder and the complete file name.
- Enterprise Guide: Specify &path and the complete file name.

Run the LIBNAME statement.
Navigate to your list of libraries and open the NP library. How many tables are there in the NP library?

Answer:

/* Enterprise Guide: */

libname np xlsx "&path/np_info.xlsx";

In the SAS studio, I can easily find the NP library in the Libraries folder. But in Enterprise Guide, I simply don't know where location of the library I created and how to get access to it.

Re: I cannot find the library I created in Enterprise Guide

Kurt_Bremser — Mon, 26 Sep 2022 03:48:40 GMT

Go back to the setup instructions and see how the macro variable &path should be set. I do not think that it should contain the path to WORK.

Re: I cannot find the library I created in Enterprise Guide

jebjur — Mon, 26 Sep 2022 14:44:59 GMT

After you submit the LIBNAME statement in Enterprise Guide, sometimes you need to right-click on your 'Local' server in the server list and select 'Refresh' in order to see the newly created library. Does that allow the NP library to show in the list?

Re: I cannot find the library I created in Enterprise Guide

Ericv123 — Tue, 27 Sep 2022 19:42:28 GMT

I have the exact same issue as previous poster. Log shows that my Libname statement is correct and 'NP" library is created but not populated in the list of libraries (even after I refresh)

Re: I cannot find the library I created in Enterprise Guide

Tom — Tue, 27 Sep 2022 21:18:49 GMT

@Ericv123 wrote:

I have the exact same issue as previous poster. Log shows that my Libname statement is correct and 'NP" library is created but not populated in the list of libraries (even after I refresh)

if you make a libref using the LIBNAME statement and the XLSX engine that points to an XLSX file SAS does NOT know whether your intent was to READ from an EXISTING file. So if the filename you used does not exist then the LIBNAME statement is successful but the file will exist until you actually WRITE something into it.

Re: I cannot find the library I created in Enterprise Guide

jebjur — Tue, 27 Sep 2022 21:48:39 GMT

Just to verify, if using Eguide 8.3, do you have the latest update applied? Also, make sure you are submitting your code to the correct server (if you have the ability to submit to multiple workspace servers).

For example, if I submit this code in Eguide:

make sure at the top of the program editor that you are submitting to the Local server:

The library should appear in the server list:

Re: I cannot find the library I created in Enterprise Guide

Shiauyin — Thu, 29 Sep 2022 04:11:43 GMT

I clicked the "refresh " a few times but the NP still not in the the libraries directory.

Re: I cannot find the library I created in Enterprise Guide

Shiauyin — Thu, 29 Sep 2022 04:17:33 GMT

Hi Jebjur,

This is what I saw. I still cannot find where the NP I created.

Re: I cannot find the library I created in Enterprise Guide

Kurt_Bremser — Thu, 29 Sep 2022 08:27:32 GMT

You have an incorrect path in your macro variable &PATH. It should NOT point to your WORK, but to the location of the Excel file.

Review the setup instructions and follow them.

Re: I cannot find the library I created in Enterprise Guide

jebjur — Thu, 29 Sep 2022 20:13:35 GMT

I would first take a look at the value of the &PATH macro variable with code such as the following, and browse to this location outside of Enterprise Guide (using windows explorer) to verify the NP_INFO.XLSX file actually exists.

%LET PATH=%sysfunc(pathname(WORK));
%PUT &PATH; /* will write the value of macro variable to the log */

If it doesn't, then you need to rerun the program that creates all of your external files and SAS data sets you use in the class.

If the file exists in the appropriate location, then change the '/' in your code to a '\' like the following and try again.

LIBNAME NP XLSX "&path\np_info.xlsx"

Re: I cannot find the library I created in Enterprise Guide

Ericv123 — Thu, 29 Sep 2022 20:33:28 GMT

Issue was resolved by a system reset overnight. Shut down and reboot to apply other corp updates and patches unrelated to Linux servers or my SAS EG instance. Unclear why this resolved the issue but it did...