topic Re: Library does not exist SAS 9.4 in SAS Programming

Library does not exist SAS 9.4

julianna1644 — Mon, 16 Dec 2019 22:22:26 GMT

Hi all,

I'm new to SAS and I keep getting the error 'Library does not exist'. I am using SAS 9.4 on Windows 10.

My code looks like:

libname libsas 'C:\libsas\finaldata';
data libsas.finaldata;
run;

When I run it I get:

ERROR: Library LIBSAS does not exist

I've been hunting on this board to see if I can try others solutions. What I've tried:

- Not copy and pasting.

-libname libsas 'C:\Users\MYUSERNAME\libsas\finaldata';
data libsas.finaldata;
run;

(This gives me the same error)

- putting / instead of \ (This was likely a dumb attempt but I'm new to this haha)

- Saving it to my usb and trying to use 'D:' (I got the same Library does not exist error)

- Tried a new computer. Same error.

If anyone can give me guidance or other suggestions that would be greatly appreciated.

Thank you!

Re: Library does not exist SAS 9.4

ScottBass — Mon, 16 Dec 2019 22:46:59 GMT

Base SAS, SAS EG, or SAS/Studio?

Does C:\libsas\finaldata actually exist?

Edit: run this code in your SAS session and post the results from the SAS log:

filename dir pipe "dir /b c:\";
data _null_;
   infile dir;
   input;
   put _infile_;
run;

Re: Library does not exist SAS 9.4

Reeza — Mon, 16 Dec 2019 23:05:21 GMT

SAS University Edition? If so, you need to use myfolders folder you set up during installation as your data location.

Re: Library does not exist SAS 9.4

julianna1644 — Mon, 16 Dec 2019 23:10:54 GMT

It is for a university class, and I'm using it on a school computer on campus. Does that automatically make it University Edition? I didn't download it myself. On previous assignments I haven't had to do the myfolder step, but I can see if that's something that helps. Thanks!

Re: Library does not exist SAS 9.4

ScottBass — Mon, 16 Dec 2019 23:15:33 GMT

I don't use University Edition, so this may or may not help. Or I should just step back and let @Reeza work her magic.

But try submitting:

libname myfolders list;

* or ;

libname _all_ list;

Re: Library does not exist SAS 9.4

julianna1644 — Mon, 16 Dec 2019 23:20:40 GMT

How do I find out which SAS it is beyond 9.4? It's on my university's computers, if this information helps in any way.

I ran the code as you sent me as:

libname libsas 'C:\libsas\finaldata';
data libsas.findata;

filename dir pipe "dir /b c:\libsas\finaldata";
data _null_;
infile dir;
input;
put _infile_;
run;

and received:

10 libname libsas 'C:\libsas\finaldata';
NOTE: Library LIBSAS does not exist.
11 data libsas.findata;
12
13 filename dir pipe "dir /b c:\libsas\finaldata";

ERROR: Library LIBSAS does not exist.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

14 data _null_;
15 infile dir;
16 input;
17 put _infile_;
18 run;

NOTE: The infile DIR is:
Unnamed Pipe Access Device,
PROCESS=dir /b c:\libsas\finaldata,RECFM=V,
LRECL=32767

Stderr output:
File Not Found
NOTE: 0 records were read from the infile DIR.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds

Please let me know if I inputted anything incorrectly.

Re: Library does not exist SAS 9.4

julianna1644 — Mon, 16 Dec 2019 23:34:12 GMT

I'm not sure if I'm using the University Edition. I'm using the version that my university has on all their computers, I'm sure how to determine what version it is. I'm contemplating downloading the free UE version to try this from a new angel though.

I tried both of those and they're both showing that LIBSAS does not exist. Thank you for your suggestions though.

Re: Library does not exist SAS 9.4

ballardw — Mon, 16 Dec 2019 23:36:36 GMT

Please rerun your libname code. Then go to your log, copy the code and any messages and then paste the copied code into a code box opened on the forum with the {I} icon.

For example when I use a libname statement that references a location that does not exist I get this:

529  libname junk "Q:\somefolder";
ERROR: Create of library JUNK failed.
ERROR: Error in the LIBNAME statement.

In this case I know the issue is that I have no Drive letter Q and there is no folder. If you see a similar error of the Create library failed something related to the path listed is almost always the cause unless you are providing a lot of options such as needed to connect to a remote database system like SQL Server or Oracle.

Common issues: Spelling, extra or missing letters in folders in the path.

in Unix based systems the path spelling is also case sensitive. If a folder is named "Somefolder" and you use "somefolder" that is not valid spelling. Solution: correct spelling.

In many places you may actually be connecting to a server to run the code. That server is on a different machine and likely does not have access to the hard drive of your computer. If this is the case when you attempt to connect to C:\libsas\finaldata it would be looking on the Server hard drive and the path almost certainly does not exist. The solution here depends on set up which may mean moving your files to a specific location where the server can read the files or if using Enterprise Guide a task to upload the data to a server.

If using SAS University Edition then SAS runs in a Linux "Virtual Machine" which you should have set up. It is only allowed to "see" folders in specific locations related to how the virtual machine was installed.

Any code that references the library LIBSAS will generate the error message if the library was not created. Which is why I ask to have you run just the Libname code and show the result.

Re: Library does not exist SAS 9.4

Reeza — Tue, 17 Dec 2019 01:59:45 GMT

@julianna1644 wrote:

I'm not sure if I'm using the University Edition. I'm using the version that my university has on all their computers, I'm sure how to determine what version it is. I'm contemplating downloading the free UE version to try this from a new angel though.

I tried both of those and they're both showing that LIBSAS does not exist. Thank you for your suggestions though.

Ok, you're likely not using SAS UE then and you should see your labs instructions about how to access the files. Usually they automatically connect to either your local area or somewhere else.

If you run the following and post the log we can likely tell you what you're running.

SAS Base would look like a standard IDE with just a window for code and the log.

SAS Studio would be accessed by your browser only

SAS EG would be linked to something that's sort of in between with process flows. The icon looks like a triangle. It will say EG on the launch usually though.

You can find out your version info from running the following:

proc product_status;run;

As to where to save your files and access it, I suspect your lab or instructor will have those instructions somewhere. No one bothers to set up SAS on a full lab without some base instructions in a University.

@julianna1644 wrote:

I'm not sure if I'm using the University Edition. I'm using the version that my university has on all their computers, I'm sure how to determine what version it is. I'm contemplating downloading the free UE version to try this from a new angel though.

I tried both of those and they're both showing that LIBSAS does not exist. Thank you for your suggestions though.

Re: Library does not exist SAS 9.4

mkeintz — Tue, 17 Dec 2019 03:41:02 GMT

The log messages you post

PROCESS=dir /b c:\libsas\finaldata,RECFM=V,
LRECL=32767
Stderr output:
File Not Found
NOTE: 0 records were read from the infile DIR.

tells you that the directory c:\libsas\finaldata does not exist. So you would need to create that directory first, or use a directory you know exists.

Re: Library does not exist SAS 9.4

ScottBass — Tue, 17 Dec 2019 04:23:30 GMT

You didn't run the code I sent you.

Re: Library does not exist SAS 9.4

shashank1691 — Wed, 30 Mar 2022 08:53:46 GMT

Hello,

I am getting same error with the libname and i am unable to import any data.

I tried running the code you mentioned and here are the log results

2 filename dir pipe "dir /b c:\";
3 data _null_;
4 infile dir;
5 input;
6 put _infile_;
7 run;

NOTE: The infile DIR is:
Unnamed Pipe Access Device,
PROCESS=dir /b c:\,RECFM=V,LRECL=32767

dc
FFOutput
HPHWDiag_log.txt
inetpub
Intel
pcfservice.log
PerfLogs
Program Files
Program Files (x86)
SHANKY
SWSetup
Users
Windows
NOTE: 13 records were read from the infile DIR.
The minimum record length was 2.
The maximum record length was 19.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.01 seconds

Re: Library does not exist SAS 9.4

shashank1691 — Wed, 30 Mar 2022 08:56:56 GMT

Hello,

I tried the code you mentioned and this is the log result i got.

Could you please guide?

9 libname _all_ list;
NOTE: Libref= SHASHANK
Scope= DMS Process
Engine= V9
Physical Name= C:\Users\Shashank\Desktop\SAS TEST
Filename= C:\Users\Shashank\Desktop\SAS TEST
NOTE: Libref= TMP1
Scope= DMS Process
Engine= V9
Physical Name= C:\Users\Shashank\Desktop\SAS\Demo1
Filename= C:\Users\Shashank\Desktop\SAS\Demo1
NOTE: Libref= SHWETA
Scope= DMS Process
Engine= XPORT
Physical Name= C:\Users\Shashank\Desktop\SYMPATHY EMPATHY\SAS DATA\demo1
NOTE: Libref= SASHELP
Scope= Kernel
Levels= 12
-Level 1-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG
Filename= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG
-Level 2-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp
-Level 3-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp
-Level 4-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp
-Level 5-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp
-Level 6-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp
-Level 7-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp
-Level 8-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp
-Level 9-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp
-Level 10-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp
-Level 11-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp
-Level 12-
Engine= V9
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\tmine\sashelp
Filename= C:\Program Files\SASHome\SASFoundation\9.4\tmine\sashelp
NOTE: Libref= MAPS
Scope= Kernel
Engine= V9
Access= READONLY
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps
Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps
NOTE: Libref= MAPSSAS
Scope= Kernel
Engine= V9
Access= READONLY
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps
Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps
NOTE: Libref= MAPSGFK
Scope= Kernel
Engine= V9
Access= READONLY
Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk
Filename= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk
NOTE: Libref= SASUSER
Scope= Kernel
Engine= V9
Physical Name= C:\Users\Shashank\Documents\My SAS Files\9.4
Filename= C:\Users\Shashank\Documents\My SAS Files\9.4
NOTE: Libref= WORK
Scope= Kernel
Engine= V9
Access= TEMP
Physical Name= C:\Users\Shashank\AppData\Local\Temp\SAS Temporary
Files\_TD9176_LAPTOP-0J3S2GHG_
Filename= C:\Users\Shashank\AppData\Local\Temp\SAS Temporary
Files\_TD9176_LAPTOP-0J3S2GHG_

Re: Library does not exist SAS 9.4

Kurt_Bremser — Wed, 30 Mar 2022 09:35:42 GMT

Please post the log of the LIBNAME statement that fails.

Re: Library does not exist SAS 9.4

shashank1691 — Wed, 30 Mar 2022 12:14:16 GMT

Hello,

When I try to import xlsx file, after selecting the file and clicking okay,

I get a prompt "Connection Failed: Please check the log window".

The result I get in Log window is below:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

Re: Library does not exist SAS 9.4

Kurt_Bremser — Wed, 30 Mar 2022 13:15:59 GMT

I'm confused. Are we now talking about a library that fails to assign, or a PROC IMPORT of an xls file?

Please post the complete log of what fails, code and all messages, and post it into a window opened with this button:

Re: Library does not exist SAS 9.4

shashank1691 — Sun, 03 Apr 2022 06:06:58 GMT

Sorry for the confusion..

I am unable to import any file...

So basically when we import any file (.xlsx/xls, .csv) or any format..

I went like, File -> Import Data -> Select format -> Browse file -> (When I select Excel) ------> Connection failed (Check log for details)

Importing .xls

Log details:

ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.

When I import .csv file File -> Import Data -> Select format -> Browse file -> (When I select .csv) ------>

PROC IMPORT OUT= WORK.FAMILYHD 
            DATAFILE= "C:\Users\Shashank\Desktop\DEN SD & HD plan list (
1).csv" 
            DBMS=CSV REPLACE;
     GETNAMES=YES;
     DATAROW=2; 
RUN;

When I run this code this is the log detail I get

NOTE: The LocalTime has been updated. NOTE: This is likely due to a Daylight Savings Time or Timezone change. NOTE: NOTE: The LocalTime has been updated. NOTE: This is likely due to a Daylight Savings Time or Timezone change. NOTE: NOTE: Import Cancelled. 1 PROC IMPORT OUT= WORK.FAMILYHD 2 DATAFILE= "C:\Users\Shashank\Desktop\DEN SD & HD plan list ( 3 1).csv" 4 DBMS=CSV REPLACE; 5 GETNAMES=YES; 6 DATAROW=2; 7 RUN; ERROR: File is in use, C:\Users\Shashank\Desktop\DEN SD & HD plan list (1).csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.23 seconds cpu time 0.04 seconds

Kindly suggest..

Re: Library does not exist SAS 9.4

Kurt_Bremser — Sun, 03 Apr 2022 06:16:12 GMT

So this has nothing to do with a LIBNAME statement.

Your first issue can have two reasons

SAS/ACCESS to PC Files is not installed or not licensed
Your MS Office has a d8fferent bitness (32/64) than your SAS.

For the second issue, make sure that Excel (or other software) is no longer keeping the csv file open.

Re: Library does not exist SAS 9.4

shashank1691 — Mon, 04 Apr 2022 05:54:46 GMT

Hello,

IT WORKED!!

Thank you so much. Like you told, my MS office was installed in 32 bits and after I changed it to 64 bit and closed all open windows, I was able to Import both CSV and Excel files.

Thanks a lot.

Re: Library does not exist SAS 9.4

Kurt_Bremser — Mon, 04 Apr 2022 06:27:02 GMT

Note that you only need a 64-bit Office for .xls files. .xlsx has a newer engine in SAS that is completely platform- and bitness-independent.

And csv files don't need anything (read: SAS/ACCESS to PC Files) at all, you can read them with a data step out of the box.