topic Re: Cannot assign library - NOTE: Library ORION does not exist. in SAS Enterprise Guide

Cannot assign library - NOTE: Library ORION does not exist.

MartensS — Mon, 11 Nov 2013 15:52:07 GMT

Hello,

I just started using SAS Enterprise Guide. And i keep getting this error.

NOTE: Library ORION does not exist.

I do not understand what i am doing wrong here.

This is my program code:

libname orion 'D:\Documenten\My SAS Files\ECPRG1';

And as you can see in the image, the file path is correct.

Im most likely doing something stupid but i can't see it.

*edit* Is it possible he can only search for a direction on the SAS server? and not locally?

*edit2* Nvm, im using SAS On Demand which means i have to link to the file on the server, i was reading the wrong manual.

libname orion '/tutorials/eg/data/ecprg1';

Thanks in advance

Simon

Re: Cannot assign library - NOTE: Library ORION does not exist.

Astounding — Mon, 11 Nov 2013 16:23:52 GMT

For the future, one way to investigate would be to list out the locations of all your SAS data sets:

proc sql;

create table all_datasets as select * from dictionary.tables;

quit;

Good luck.

Re: Cannot assign library - NOTE: Library ORION does not exist.

Cynthia_sas — Mon, 11 Nov 2013 23:47:30 GMT

Hi, If you are using SAS OnDemand for Professionals server, then the SAS Enterprise Guide client that you are using does NOT have any visibility of your local 😧 drive or C: drive to point to SAS datasets. The OnDemand server is a Unix server located in North Carolina.

If you are taking Programming 1 as an e-learning course, as indicated by your final LIBNAME statement:

libname orion '/tutorials/eg/data/ecprg1';

Then this is the correct LIBNAME statement to point to the Programming 1 data that is already loaded on the server.

cynthia

Re: Cannot assign library - NOTE: Library ORION does not exist.

Saszealot — Mon, 09 Dec 2013 20:07:51 GMT

You're probably the best person to answer my question.

I'm trying to create Library : ORION On SAS Enterprise guide : SAS ONDEMAND FOR ACADEMICS.

I listened to the lecture several times and demo and followed the steps. SE directs me to the library on your Servers - SASApps, but can' create ORION Library.

Below is part of the steps SAS people gave to in their solution to the practice:

Task

Use the Assign Project Library task to create the Orion library and point to the location of the course data. Include the access=readonly option in Step 3 of the task. Then, test and assign the library.

Select Tools Assign Project Library.
In Step 1, type Orion in the Name field and select Next.
In Step 2, verify that the engine is BASE. Browse to or type the location of the course data. Select Next.
In Step 3, type access in the Name field. Then, type readonly in the Value field. Select Next.
In the final step, select Test Library and verify that OK is displayed. Select Finish.

Re: Cannot assign library - NOTE: Library ORION does not exist.

MartensS — Mon, 09 Dec 2013 20:14:36 GMT

I assign the library this way:

I created a program with the following code

libname orion '/tutorials/eg/data/ecprg1';

Then i run it everytime i start SAS Enterprise Guide.

After you run this code, make sure you check the log to see if it was succesfully assigned.

Re: Cannot assign library - NOTE: Library ORION does not exist.

Saszealot — Mon, 09 Dec 2013 21:04:41 GMT

Thanks a lot, I was able to create the ORION Library going by your advice, but the specific data I'm looking for employee_masters is missing in that Library and the content is not the same as that in ECEG151.

Re: Cannot assign library - NOTE: Library ORION does not exist.

Cynthia_sas — Tue, 10 Dec 2013 01:24:57 GMT

Hi:

ECPRG1 is the appropriate folder to use when you are taking the PROGRAMMING 1 e-learning course (just as ECSQL1 would be the folder for the SQL1 e-learning course). Since you indicated in your previous post that you were using SAS OnDemand for Academics, you would want to follow the instructions given to you by your professor. For example, in my response to your other post, I showed you the folders that I see on the OnDemand for Professionals server. Remember that you cannot navigate to a location on your C drive. the ECPRG1 location will NOT work for you if you are taking the Enterprise Guide 1 course or a specific course at your university for which your professor has loaded the data.

cynthia

Re: Cannot assign library - NOTE: Library ORION does not exist.

ghiottos — Thu, 06 Mar 2014 17:19:36 GMT

Hello Cynthia,

I recently started the SCYP programme and am now doing the Enterprise Guide 1: Querying and Reporting e-learning course.
I seem to have the same or a very similar problem, I also cannot find the Employee_master file required to do the practice. It is supposed to be in the Orion Library that I should assign, but I cannot find any library with the employee_master file. The specific practice session is enterprise guide 1: querying and reporting==> Lesson 2: Working with Data in a Project ==> Accessing SAS and DBMS Data ==> the second practice session (ie, the last item of Accessing SAS and DBMS Data).

I'm hoping you or one of your colleagues can help me as this is a bit of a bottleneck to continue the course.

Kind regards,

Simon

Re: Cannot assign library - NOTE: Library ORION does not exist.

Cynthia_sas — Fri, 07 Mar 2014 17:22:19 GMT

Hi:

Every e-learning class has a different directory location. Only the Enterprise Guide 1 class uses the EMPLOYEE_MASTER dataset. So you will not find that data in any of the other locations (such as the directory for Programming 1 or Programming 2). However, when I look at the SAS OnDemand for Professionals server, I DO see EMPLOYEE_MASTER in the location described in the Enterprise Guide 1 course. See the screen shot entitled: path_to_data_server.png -- which shows a screen from the course that names the path in the server list. Then see screen shot employee_master_on_server.png to see that the EMPLOYEE_MASTER data set is on the server. That screen shot also shows an example of a possible LIBNAME statement and PROC CONTENTS step that should work on the OnDemand server (assuming the same directory structure), to point to the data file. The difference between Method 1 and Method2 below is that Method 1 uses the tilde character ~ as an alias for the /home/your_username portion of the directory location -- which I find easier to type. Method 2 shows the LIBNAME statement as generated by Enterprise Guide (it uses the full directory path and, of course, you would have to substitute your username where I have indicated your_username in the code below). Or, just use the tilde method. Just remember each time you log onto the server, you will need to either Assign the library from the Tools menu or have a LIBNAME statement that you submit first.

cynthia

** Method 1;

libname orion '~/ecourses/eceg151';

proc contents data=orion.employee_master;

run;

proc print data=orion.employee_master;

run;

** Method 2;

LIBNAME ORION BASE "/home/your_username/ecourses/eceg151" access=readonly;

proc contents data=orion.employee_master;

run;

proc print data=orion.employee_master;

run;

As an alternative, you could go to the tools menu (Tools --> Assign Project Library) and assign a library to your project by following these screen shots: eg_assign_lib_tools_method.png.

So when I issue aLIBNAME statement, no matter which form, I do see all the DATASETS that are stored in the directory for the Enterprise Guide 1 e-learning class. The path to the data was in the class material. The relevant choice is to pick the SAS OnDemand button. It might say SAS OnDemand for Professionals, but that would also apply to SAS OnDemand for Academics server too (if the data for that course is on the Academics server).

cynthia

Re: Cannot assign library - NOTE: Library ORION does not exist.

ghiottos — Thu, 13 Mar 2014 22:19:41 GMT

Hello,

I am sorry to say that it didn't work. I tried all three of the methods you told me over the last week as well as experimenting a bit myself based on the earlier course 'Introduction to Statistical Concepts' that I already finished and where I did not have a problem with the data but to no avail.

As you guessed I am using the SAS Enterprise Guide 6.1 OnDemand for Academics, but I don't seem to have access to the server.

In the attached image you can see a screenshot of what I get when I use the first method, but it's the same for the second method. When I try to use the third method(tools menu) I don't even see the other folders in the second step when I want to select the folder. My only option is the sasuser.v93 that I also see in your screenshot, but you seem to have more options.

Note that in my screenshot I purposely included the Server List, where according to the path to data screenshot you sent me I am supposed to have more options.

Could it be that I made a mistake in a much earlier step, during my registration for the SCYP programme or when downloading/setting up the Enterprise Guide OnDemand?

Kind regards,

Simon

Re: Cannot assign library - NOTE: Library ORION does not exist.

Cynthia_sas — Fri, 14 Mar 2014 03:03:51 GMT

Hi: I was afraid that the directories on the SAS OnDemand for Academics server might be different that what is on the SAS OnDemand for Professionals server. They are 2 different servers used for 2 different purposes. Generally, the SAS OnDemand for Academics server has a professor's course data loaded on the server. Your screen shots indicate to me that your server structure and loaded files are different than what is on the SAS OnDemand for Professionals server that I have access to. There isn't a way for you to put files onto the server. Usually when a SAS OnDemand for Academics student takes a class, their professor makes sure that the class data is loaded onto the server for the class they are taking. I do not know what program or university runs your SCYP program, but you might need to work with your professor to see whether he/she has arranged for data to be loaded onto the server.

Clearly, the EG directory that I can see for the EG course is not on your server. That is really a question for your professor.

cynthia

Re: Cannot assign library - NOTE: Library ORION does not exist.

krott — Tue, 17 Jun 2014 17:34:29 GMT

I too am having trouble loading the Orion library with the , but I am using the Base SAS setup for Windows. I am typing in what the instructions say, but am getting the error that the Library Orion does not exist.

this is what I have per the instructions provided:

%let path=\Users\Krott\Desktop\ecprg193;

libname orion "&path";

I am really new to this and don't understand. Any help you can provide is greatly appreciated.

Re: Cannot assign library - NOTE: Library ORION does not exist.

Cynthia_sas — Tue, 17 Jun 2014 23:02:37 GMT

Hi:

Are you using a local copy of SAS on your machine (your C: drive) or are you using the SAS University Edition and a Virtual Machine? If you are running SAS on your local machine (NOT through the SAS University Edition), then the instructions for Programming 1 are to use the FULLY qualified path. On Windows, a FULLY qualified path includes the C:\ drive letter. For example, if I want to write the files to a folder named C:\SAS_Education\ecprg1 folder then my code and libname would need to be typed as shown in the screen shot of the attached SAS log. And, you can see from the Windows Explorer screen shot that the program ran successfully. To determine whether you do have a local copy of SAS, you should look for the SAS.EXE executable program on your C: drive or a shared drive that is attached to your machine.

If you are using the SAS University Edition, which lives in a Virtual Machine on your desktop, then the location is a different location that you specify. It would need to be a UNIX location, with UNIX slashes, something like:

/folders/myfolders/ecprg1 (assuming you followed the instructions to make a shared folder for your Virtual Machine).

Since you indicated that you have the "Base SAS setup for Windows", then I have only attached screen shots for setting up the libname and creating the data for that setup.

cynthia

Re: Cannot assign library - NOTE: Library ORION does not exist.

krott — Thu, 17 Jul 2014 17:50:21 GMT

Thank you Cynthia.

It turns out we are using SAS on a server and I had to get the files over using an FTP software. Got it all up and running.l Thank you for your response. It was helpful in getting me to go in the right direction.

Re: Cannot assign library - NOTE: Library ORION does not exist.

garrisonplessinger — Tue, 16 Sep 2014 03:23:02 GMT

I am having the same issue, I am using VMPlayer and The SAS University Edition to do the e course, it seems that i don't have the data files downloaded.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 %let path=C:\Users\Garrison\Documents\SAS\SASUniversityEdition\myfolders/ecprg193;

44 libname orion "&path";

NOTE: Library ORION does not exist.

45 ;

46 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 ;

Re: Cannot assign library - NOTE: Library ORION does not exist.

Reeza — Tue, 16 Sep 2014 03:30:50 GMT

You can't assign paths like that in SAS University Edition. Note the use of backward and forward slashes in your path for one.

There's a few FAQ's on how to assign it on here, as well as in the instructions for the University Edition.

http://support.sas.com/software/products/university-edition/faq/shared_folder_access_existing.htm

http://support.sas.com/software/products/university-edition/faq/shared_folder_access.htm

Re: Cannot assign library - NOTE: Library ORION does not exist.

garrisonplessinger — Tue, 16 Sep 2014 03:47:48 GMT

Thank You! We are up and running.

Re: Cannot assign library - NOTE: Library ORION does not exist.

court3115 — Fri, 06 Feb 2015 13:55:48 GMT

I am using Windows Base SAS from a virtual lab and am unable to create the Orion library. Any idea where I need to point it to? Tried everything above to no avail.

Re: Cannot assign library - NOTE: Library ORION does not exist.

ChrisHemedinger — Fri, 06 Feb 2015 14:11:30 GMT

"Orion" data, also known as Orion Star data, are sample data sets that are used within SAS Education classes. See this thread for more details.

Unless your environment has been staged for use in the same way an official SAS training course would be, you might not have access to the Orion data.

Or, it's possible that if you're using a self-paced E-learning module, the instructions for downloading the sample Orion data have been provided. If someone else is administering your virtual lab, you might need to check with that person for the specific instructions to access it.

Chris

Re: Cannot assign library - NOTE: Library ORION does not exist.

court3115 — Fri, 06 Feb 2015 14:23:33 GMT

Thanks Chris. I am doing the online SAS training course on my own and am accessing the SAS Base software through a virtual lab, there is no contact information for that. Since it is not on my actual computer, I'm not sure that I can access the Orion data at all, since the SAS program is sitting on a different machine.