topic Re: Error message in SAS Procedures

Error message: Libname is not assigned

maddyjoshi29 — Thu, 07 Jul 2016 17:19:25 GMT

while working encountered error message ERROR: Libname <dataset>is not assigned.please help to understand and remedy

7 proc print data=in2.prac;
ERROR: Libname IN2 is not assigned.
8 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

Re: Error message

ballardw — Thu, 07 Jul 2016 17:23:31 GMT

@maddyjoshi29 wrote:

while working encountered error message ERROR: Libname <dataset>is not assigned.please help to understand and remedy

7 proc print data=in2.prac; < this line says the data set to print named PRAC is in the library named IN2.
ERROR: Libname IN2 is not assigned.
8 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

If the library has not been assigned for the current session then SAS cannot find the data. A libname statement similar to:

LIBNAME IN2 "C:\path\foldername";

is one way to provide a library. If you use the menu (such as Tools>New Library) to create a library you may need to indicate "make it permanent" by checking a box to make the system automatically assign the the library the next time SAS starts. The exact approach varies between Base SAS, Enterprise Guide, SAS Studio and University Edition (varies a LOT for UE).

Re: Error message

maddyjoshi29 — Thu, 07 Jul 2016 17:45:03 GMT

I am using SAS version 9.0. I cant see option for new library in tools.... what I am trying to do is , though I have been doing this from quite some time and successfully done it before but now getting error.

I go to file > import data( saved in 97,2003 format in excel in drive and save in as folder in one of my library... I have attached the screenshot of steps for your reference.

Re: Error message

ballardw — Thu, 07 Jul 2016 18:59:34 GMT

Screen shots didn't attach apparently.

Which LIBRARY did you tell the import to go to? The default would likely have been WORK. If you didn't assign a library you might look in the SAS Explorer window for a library with an odd name and look there for the data file. If so, change the proc print to use that library name instead of IN2.

Re: Error message: Libname is not assigned

Reeza — Thu, 07 Jul 2016 19:47:38 GMT

I doubt you're using SAS 9.0, can you confirm with the following code, check your log for the output:

%put &sysver;

Navigate to your library/folders window on the left hand side. Do you see a library called IN2? If not, you can create it using the code previously suggested.

If this is a library that you expect to be pre-assigned, ie assigned when you start up, it could be either a temporary network glitch when you started SAS didn't allow for the library to be assigned or something changed.

Re: Error message

maddyjoshi29 — Fri, 08 Jul 2016 05:04:13 GMT

I have already created a library (by the name of Recorded) and saved my imported excel file by the name of IN2.
And when I write -
Proc Print data=In2.recorded;
run;
it doesn't run and gives that error in log.

Re: Error message: Libname is not assigned

maddyjoshi29 — Fri, 08 Jul 2016 05:06:55 GMT

hello Reeza,

I will check that though but I'm sure using ver-9.0
I had been able to create library and run the code previously... nevertheless will check again and keep posted.

Re: Error message: Libname is not assigned

Cynthia_sas — Fri, 08 Jul 2016 15:41:05 GMT

Hi:

The LIBRARY is a nickname for a physical path location on your operating system or server. For example, these all define the ORION library:

Windows: libname orion 'c:\temp\classes\pg1';
Unix: libname orion '/unx/classes/pg1';
Mainframe: libname orion 'SASCZZ.DATA.CLASSES.PG1' DISP=SHR;
SAS on Demand server: libname orion '/home/cynther0/pg1';
SAS University Edition: libname orion '/folders/myfolders/ecprg193';

Once you have the library defined, then you can run PROC CONTENTS to see the names of the datasets stored in the library:

proc contents data=orion._all_;
  title 'what are the datasets';
run;

Then, you refer to the datasets by their 2 level name. So, let's take Windows as an example. If I have

Physical file name, as stored on disk: c:\temp\classes\pg1\customers.sas7bdat
LIBNAME statement: libname orion 'c:\temp\classes\pg1';

Then to print the rows, I would use this code:
proc print data=orion.customers;
title 'Orion.Customers';
run;

As you can see, ORION (the name of the library) is the first part of the 2-level name and CUSTOMERS (the file name of the physical file) is the second part of the 2-level name.

This is how the LIBNAME works, no matter what version of SAS you are using.

cynthia

Re: Error message

ballardw — Fri, 08 Jul 2016 16:56:08 GMT

@maddyjoshi29 wrote:
I have already created a library (by the name of Recorded) and saved my imported excel file by the name of IN2.
And when I write -
Proc Print data=In2.recorded;
run;
it doesn't run and gives that error in log.

The reference is always library.dataset, not dataset.library.

proc print data=recorded.in2;

Re: Error message

maddyjoshi29 — Fri, 08 Jul 2016 17:14:32 GMT

oh my god... I didnt even notice this mistake.. thank you so much ballardw :):).. appreciate your effort.. thanks a
ton