topic Libname created in log but not appearing in list of libraries in Programming 1 and 2

Libname created in log but not appearing in list of libraries

crzydzy — Tue, 07 Jun 2022 02:07:53 GMT

Lesson 2: Accessing Data: Creating an excel libref.

I succesfully created the code using SAS Enterprose, ran the program, no errors, NP was successfully assigned. Problem is that the NP libname does not appear in my list of libraries. Where is it? I know it exists because I am able to complete the rest of the activity and SAS recognizes the library as I am writing the proc contents data=np.parks

Re: Libname created in log but not appearing in list of libraries

Reeza — Tue, 07 Jun 2022 02:11:04 GMT

If you press refresh does it show up?

Re: Libname created in log but not appearing in list of libraries

Kurt_Bremser — Tue, 07 Jun 2022 08:16:43 GMT

This LIBNAME statement will always work:

libname test xlsx "some place that positively does not exist at all";

because you can use LIBNAME XLSX (and other similar engines) to create a new file. The ERROR will happen when you try to create a dataset in the library, or when you try to read something from there.

Your most probable mistake is using the local path to the Excel file in your code, while your SAS process runs in fact on a remote server.

Please post your code, and the log from this:

%put %sysfunc(pathname(work));

Re: Libname created in log but not appearing in list of libraries

Cynthia_sas — Tue, 07 Jun 2022 18:45:56 GMT

Hi: Watch where you have your libname np clear; statement. Most of our examples show the use of the LIBNAME statement to point to the Excel workbook and then after the SAS code, we typically show a CLEAR for the LIBNAME. The reason is that Excel gets touchy when SAS holds a file open with the LIBNAME engine and can issue nasty "read-only" messages if you try to open the file in Excel while SAS is using it. If you look at your libraries list AFTER your program does the clear, you will no longer see the XLSX defined library in your list.

Cynthia

Re: Libname created in log but not appearing in list of libraries

crzydzy — Tue, 07 Jun 2022 19:41:14 GMT

Refreshing does not make the NP library appear.

As I proceed with the coding for the rest of the activity, the 3 data sets
(in the library) pop up in the suggestive mode feature in SAS Enterprise.

FYI, I have looked in every library on the server and I could not find it.
I even looked on my local hard drive to see if it were someplace.