topic Libname - Library does not exist in SAS Programming

Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 17:31:58 GMT

Hello,

I am using SAS 9.3 in a 64 bit Windows 7 environment. When I run the following libname 'EXTRACTS V9 "c:\sas_datasets\extracts";' I get the message 'NOTE: Library EXTRACTS does not exist'. The file location is valid and the datasets are present in this directory.

Some background on my issue - I am trying to schedule a program to run using windows task scheduler. The SAS program works fine when I log into SAS and execute the program myself. When I run the program from windows scheduler, I get the message saying the libraries don't exist. I inserted 'libname _all_ list;' at the start of my program and it showed that the library is there (text below)

13 libname _all_ list;

NOTE: Libref= EXTRACTS

Scope= Program "C:\sas_code\prod_code\extracts reporting\manual\2 report date range.sas"

Engine= V9

Physical Name= c:\sas_datasets\extracts

Filename= c:\sas_datasets\extracts

The only difference I was able to find was in the scope field. When I run the program manually, the scope = DMS Process and when it is run from scheduler, scope = the sciprt name. Any direction would be helpful.

Thanks

Drew

Re: Libname - Library does not exist

Reeza — Mon, 24 Jun 2013 17:42:25 GMT

If this is the code you're submitting I don't think its valid:

libname 'EXTRACTS V9 "c:\sas_datasets\extracts";'

It should be:

libname EXTRACTS "c:\sas_datasets\extracts";

Otherwise, post the exact code you're submitting.

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 17:45:19 GMT

Thanks for the quick response! I added the single quotes for the post. The exact libname at the top of my code is below. I tried with and without the V9.

EXTRACTS V9 "c:\sas_datasets\extracts";

Thanks

Drew

Re: Libname - Library does not exist

Reeza — Mon, 24 Jun 2013 17:49:39 GMT

Missing the word libname? or just a typo again?

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 17:54:46 GMT

Ah, a copy/paste issue this time;) For some reason, when I paste it into IE browser, libname disappears.

LIBNAME EXTRACTS V9 "c:\sas_datasets\extracts";

Thanks

Drew

Re: Libname - Library does not exist

Linlin — Mon, 24 Jun 2013 18:38:31 GMT

Does V9 make a difference? I never use that in my libname statement.

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 19:21:14 GMT

The V9 did not change the outcome for me.

Thanks

Drew

Re: Libname - Library does not exist

Reeza — Mon, 24 Jun 2013 19:26:54 GMT

So the following works in open code:

LIBNAME EXTRACTS V9 "c:\sas_datasets\extracts";

but doesn't work in batch .

What about when you %include the program? or is it only via windows scheduler where the error happens?

Re: Libname - Library does not exist

esjackso — Mon, 24 Jun 2013 19:35:45 GMT

Are you using a local version of SAS or is SAS on a server?

Nevermind - Windows 7 was listed

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 19:39:01 GMT

Thanks for the reply! The issue is only occuring when it is run through the scheduler. If I run the program manually (open sas and hit submit), it runs fine. I am running local version of SAS.

Thanks again!

Drew

Re: Libname - Library does not exist

esjackso — Mon, 24 Jun 2013 19:40:30 GMT

We got a similar errors when we referenced mapped drive on our network without using the full network path in the sas program. You might want to try checking the option Run with highest privileges to make sure SAS has privileges on C: .

Re: Libname - Library does not exist

Doc_Duke — Mon, 24 Jun 2013 20:21:44 GMT

Drew,

Some other thoughts:

-- can you run the program in batch WITHOUT the scheduler?

-- is your interactive SAS running an autoexec script that is changing the configuration on you? The log should show if something is being run even if it doesn't provide the details.

Are you running 64 bit SAS or 32 bit SAS (both will run in the Win 7-64 bit environment). I assume you have Win 7 Pro or higher.

Doc Muhlbaier

Duke

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 20:29:56 GMT

Thanks! I do have run with highest privelages checked in the scheduler.

I am relativelty new to SAS and I may not have been clear when I initially explained my problem. When I run the program manually (open sas and execute), I do not have the libname statement included because I do not get any errors in the program.

When I run the program from Windows Task Scheduler, I get the error ERROR: Libname EXTRACTS is not assigned.

Because of the above mentioned error, I added the libname statement (to assign the libname) which resulted in the error ERROR: Library EXTRACTS does not exist.

If I run the libname statement all by itself, I still ger the error ERROR: Library EXTRACTS does not exist.

The only difference I was able to find was in the results of libname list all listings.

Code without libname

NOTE: Libref= EXTRACTS

Scope= DMS Process

Engine= V9

Physical Name= C:\sas_ datasets\extracts

Filename= C:\sas_ datasets\extracts

Code with the libname

NOTE: Libref= EXTRACTS

Scope= Program "C:\sas_code\prod_code\extracts reporting\manual\2 report date range.sas"

Engine= V9

Physical Name= c:\sas_datasets\extracts

Filename= c:\sas_datasets\extracts

I am running SAS 9.3 TS level 1M1 W32_7PRO platform.

Thanks again for your help!

Drew

Re: Libname - Library does not exist

Linlin — Mon, 24 Jun 2013 20:37:14 GMT

could you open your sas and highlight the below libname statment and run it, then check the log file?

LIBNAME EXTRACTS "c:\sas_datasets\extracts";

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 20:40:10 GMT

Thanks for the response!

The log details are below.

9708 LIBNAME EXTRACTS "c:\sas_datasets\extracts";

NOTE: Library EXTRACTS does not exist.

Thanks!

Drew

Re: Libname - Library does not exist

Reeza — Mon, 24 Jun 2013 20:42:18 GMT

Most likely that path doesn't exist then.

If you copy and paste that directory into a windows explorer does it work?

Re: Libname - Library does not exist

Doc_Duke — Mon, 24 Jun 2013 20:42:33 GMT

Drew,

did you cut-n-paste the "physical Name"'s above? There is an embedded blank after the "_" in the DMS Process one that does not exist in the code with the libname.

Doc

Re: Libname - Library does not exist

qh8519a — Mon, 24 Jun 2013 21:07:04 GMT

Wow - something so simple. There was an additional space in the file directory name. Thanks for all the help!

Re: Libname - Library does not exist

esjackso — Mon, 24 Jun 2013 21:10:00 GMT

I refuse to tell how often Ive been bit by that over the last 10+ years.

Glad you got it solved!

Re: Libname - Library does not exist

omkar22k — Fri, 24 Jul 2015 10:19:24 GMT

Hi,

I am using SAS on a server and I have been irritated to the core in searching for a solution for this issue.

I am trying to create a new library by entering the following

LIBNAME DAT 'C:\Users\omkark\Desktop\SAS';

And am getting the following message:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

58 LIBNAME SAS 'C:\\Users\\omkark\\Desktop\\SAS';

NOTE: Library SAS does not exist.

61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Please do guide me accordingly.

Thanks in advance.