topic Re: Library PG1 does not exist in SAS Enterprise Guide

Library PG1 does not exist

NSK — Thu, 06 Sep 2018 15:22:16 GMT

Hi,

I am new to SAS and working through the SAS Programming 1: Essentials training. I am using SAS Enterprise Guide and I am connected to a SAS server. I am trying to set up my practice files. I am using the instructions provided for SAS Windowing Environment. I copied the folder into the SAS drive and replaced the FILEPATH with the actual path for the folder. When I run the program, I get this error "LIbrary PG1 does not exist.". I have seen answers for similar posts but I am unable to figure out why this is not working. Please see the code below. I would really appreciate if someone can help with this.

%let path = F:\NSK\SAS_Training\EPG194;

libname PG1 "&path";

Thanks,

NSK

Re: Library PG1 does not exist

ballardw — Thu, 06 Sep 2018 15:42:56 GMT

If you are running EG connected to a server then the SERVER has to see the path. If the server does not have an F drive mapped then it "doesn't exist".

You need to ensure that the path is acceptable to the server. If the location is on a network shared drive or such you may need to use a different reference from the server's perspective. If the F drive is a local drive to your computer you will need to work with your SAS admin and/or IT folks to set up a share or something. Or use a different location both you and the server can access.

Re: Library PG1 does not exist

NSK — Thu, 06 Sep 2018 17:08:56 GMT

Thank you for your quick response. The F drive is mapped to the SAS server. I am also able to see the folder in question under Servers -> SASApp -> Files on the left hand of the SAS Enterprise Guide.

Can you think of anything else that could be an issue?

Re: Library PG1 does not exist

Tom — Thu, 06 Sep 2018 17:37:50 GMT

Is the path the same? Your SASapp server is running Windows also?

Re: Library PG1 does not exist

jebjur — Thu, 06 Sep 2018 17:42:16 GMT

Try using the UNC path instead of a mapped drive letter when you submit the LIBNAME statement from Enterprise Guide.

Re: Library PG1 does not exist

ballardw — Thu, 06 Sep 2018 17:45:20 GMT

When you run this code:

%let path = F:\NSK\SAS_Training\EPG194;

libname PG1 "&path";

Do you get a result in the log that looks like:

NOTE: Libref PG1 was successfully assigned as follows:

If not, then the library wasn't assigned and doesn't exist and you should perhaps post the log from running the LIBNAME statement.

Re: Library PG1 does not exist

NSK — Thu, 06 Sep 2018 17:58:52 GMT

Please see the log below:

1 %_eg_hidenotesandsource;
5 %_eg_hidenotesandsource;
28
29 %let path = F:\NSK\SAS_Training\EPG194;
30
31 libname PG1 "&path";
NOTE: Library PG1 does not exist.
32
33 %_eg_hidenotesandsource;
45
46
47 %_eg_hidenotesandsource;
50

Re: Library PG1 does not exist

NSK — Thu, 06 Sep 2018 18:08:21 GMT

Thank you very much. I didnt know what UNC path is. I looked it up and replaced the F drive with the UNC path. And I cant believe but it worked.

1 %_eg_hidenotesandsource;
5 %_eg_hidenotesandsource;
28
29 %let path = \\server1088\Files\NSK\SAS_Training\EPG194;
30
31 libname PG1 "&path";
NOTE: Libref PG1 was successfully assigned as follows:
Engine: V9
Physical Name: \\server1088\Files\NSK\SAS_Training\EPG194
32
33 %_eg_hidenotesandsource;
45
46
47 %_eg_hidenotesandsource;
50

Re: Library PG1 does not exist

fernandavello — Wed, 28 Aug 2019 03:05:27 GMT

I was going crazy here. I finally got it after copying my folder's path and pasting it into the code. You guys opened my eyes.

Re: Library PG1 does not exist

toks020 — Fri, 20 Sep 2019 15:50:12 GMT

I have tried to copy the path to my folders but it still gives error someone should please help. I don't know if there is something that I an doing wrong.

%let path= C:\Users\Nurat\Documents\EPG194;

libname PG1 "&path";

Re: Library PG1 does not exist

cloudyeye — Tue, 03 Dec 2019 04:59:37 GMT

I am having this issue too, even after reading this forum.

Initially I ran this as a tutorial I was following told me to:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

71 /***********************************************/

72 /* In the line of code below, replace FILEPATH */

73 /* with the path to your EPG194/data folder */

74 /***********************************************/

76 %let path=~/EPG194/data;

78 /**********************************************/

79 /* DO NOT EDIT THE CODE BELOW */

80 /**********************************************/

82 libname PG1 "&path";

NOTE: Library PG1 does not exist.

86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Then I tried to use the folder location to resolve the error but that didn't work (because it is not the UNC path? I don't know what the UNC path is...)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

71 /***********************************************/

72 /* In the line of code below, replace FILEPATH */

73 /* with the path to your EPG194/data folder */

74 /***********************************************/

76 %let path=C:\Users\claud\Documents\SAS;

78 /**********************************************/

79 /* DO NOT EDIT THE CODE BELOW */

80 /**********************************************/

82 libname PG1 "&path";

NOTE: Library PG1 does not exist.

86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Any help on what a UNC path is, how to get it and how it should be inserted into the code?

Thanks.

Re: Library PG1 does not exist

jebjur — Tue, 03 Dec 2019 15:22:17 GMT

First of all, are you connecting to a local SAS server from Enterprise Guide (Base SAS is installed on the same PC as Enterprise Guide and the connection profile is 'No Profile Selected'), or are you connecting to a remote SAS server? If a remote server, is the operating system Windows or Unix? When connecting to a remote SAS server from Enterprise Guide, the server needs to be able to access the path you are specifying on the LIBNAME statement. For example, a remote server will most likely not be set up to access the files on your local PC, but it may be able to access a shared network drive.

A UNC (universal naming convention) path uses double slashes or backslashes to precede the name of the computer. The path (disk and directories) within the computer are separated with a single slash or backslash, as in the following examples. Note that in the DOS/Windows example, drive letters (c:, d:, etc.) are not used in UNC names.

//servername/path Unix

\\servername\path DOS/Windows

For example, you may have a mapped drive on your PC that is using the drive letter 'F'. 'F' is actually mapped to a network server named server123 and a directory named SAS_Files. Your training files are located in the subdirectory EGP194 within SAS_Files. So instead of using the path of 'F:\EGP194', the UNC path would be '\\server123\SAS_Files\EGP194'. Does that help?

Re: Library PG1 does not exist

cloudyeye — Tue, 03 Dec 2019 23:41:18 GMT

Okay. I understand it in theory but I don't know practically how I find out what the server name or number is for the drive holding the files. If I'm using Windows 10, what do you actually need to do to get the server info for a drive? Unsure if I would be able to correctly write out the rest of the file location after the server either.
I've just been randomly plugging in file locations for a while now, trying to sort this -_- ha

Thanks.

Re: Library PG1 does not exist

Karen29 — Wed, 04 Mar 2020 07:21:05 GMT

I have the same issue. The files are on my c:\ drive. I am using Windows 10 as the OS.

I entered:

%let path=c:\SASUniversityEdition\myfolders\EPG194\;

and I get error Library PG1 does not exist.

I can't see what I am doing wrong.

I also tried

\\localhost\c$\SASUniversityEdition\myfolders\EPG194\;

same error.

I would appreciate it assistance with what I would think would be a simple task.

Re: Library PG1 does not exist

sidd315 — Wed, 03 Jun 2020 14:37:59 GMT

Hi All

I am encountering the same issue where I am assigning a library with a UNC path and the assigning of the libraries doesn't show any error but the log in the enterprise edition says that the library does not exist.

Could you please help?

Kind Regards

Siddharth

Re: Library PG1 does not exist

toks020 — Wed, 03 Jun 2020 14:56:51 GMT

Check your Path. The error is from the link you referenced. You know you don’t have PC to SAS link. If it still does not work. I will be more than happy to help.