topic Re: Creating Libname in SAS Studio in New SAS User

Creating Libname in SAS Studio

armoore — Tue, 12 May 2020 05:15:22 GMT

option validvarname=v7;
libname Coolinfo "C:\Users\ravon\Desktop\practices";

I am attempting to create a libname; but each time in the LOG I have a note stating "Note: Library Coolinfo does not exist."

On my desktop I have a few SAS table in the practices folder. What am I doing wrong?

My version of SAS is 9.04.01M6

Re: Creating Libname in SAS Studio

Jagadishkatam — Tue, 12 May 2020 05:23:34 GMT

The libname path is case sensitive, so please check the path again and copy/paste the same from the folder

Re: Creating Libname in SAS Studio

ed_sas_member — Tue, 12 May 2020 07:12:18 GMT

Hi @armoore

I used to experience the same issue and its was solved by using slash (/) instead of back slash (\). So please, try this:

libname Coolinfo "C:/Users/ravon/Desktop/practices";

Hope this helps,

Best,

Re: Creating Libname in SAS Studio

Kurt_Bremser — Tue, 12 May 2020 11:18:43 GMT

SAS Studio is part of a server installation (as it needs a web server and web application server to run).

If the server name in your browser's address line for the Studio window is not localhost, then your SAS will most probably run on a remote server, and you cannot access your C: drive from there.

Re: Creating Libname in SAS Studio

armoore — Wed, 13 May 2020 14:41:45 GMT

I was able to get this to work

libname XO xlsx "C:/Users/ravon/Documents/np_info.xlsx";

The LOG states

NOTE: Libref XO was successfully assigned as follows:

Engine: XLSX

Physical Name: C:/Users/ravon/Documents/np_info.xlsx

Thank you

Re: Creating Libname in SAS Studio

Kurt_Bremser — Wed, 13 May 2020 17:30:03 GMT

Since the XLSX libname can be used to create a new file, SAS does not access the file before you actually try to read from or write to the library. Therefore the success of the libname statement itself does not mean anything.

Re: Creating Libname in SAS Studio

armoore — Wed, 13 May 2020 19:59:04 GMT

Because I'm not able to access my C: drive using SAS Studio. Would that be the reason why I'm not able to save data sets to that library name example.

libname XO xlsx "C:/Users/ravon/Documents/np_info.xlsx";

data XO.fastcars;
set sashelp.cars;
keep MSRP Type Origin;
run;

Also, the reason SAS studio states Library HAT does not exist for this libname statement below?

libname HAT base "C:/Users/ravon/Documents/yepyep/practices";

Re: Creating Libname in SAS Studio

Tom — Wed, 13 May 2020 20:16:26 GMT

Where is the version of SAS that you are using SAS/Studio to connect to running? Is it running on your local machine (where you are running the browser that is connecting to SAS/Studio webpage?). If you are using the free SAS University Edition then it is running in a virtual machine, so it is not really running on your machine.

But SAS/Studio provides a nice panel to let you browse the files that the SAS server can see. Find the file that you want to read (or the directory where you want to write to) in that panel. Right click on it and ask for Properties. That will show you the path that SAS is using the see that file. Copy that path into your SAS code.

Re: Creating Libname in SAS Studio

armoore — Wed, 13 May 2020 20:52:52 GMT

My version of SAS is 9.04.01M6.
Yes, Its I am running on my labtop where I have to connect to the SAS/Studio webpage.

If I right click on the folder on my desktop. Then, select properties and copy location this is what is seen C:\Users\ravon\Desktop

Re: Creating Libname in SAS Studio

Tom — Wed, 13 May 2020 21:49:51 GMT

@armoore wrote:
My version of SAS is 9.04.01M6.
Yes, Its I am running on my labtop where I have to connect to the SAS/Studio webpage.

If I right click on the folder on my desktop. Then, select properties and copy location this is what is seen C:\Users\ravon\Desktop

There isn't any "desktop" in SAS/Studio, checking the desktop on your PC does not help anything. Everything in SAS/Studio is in your browser. Look at the Server Files and Folders area of the SAS/Studio browser window for file you want and check the properties there. Can that see a folder named C:\Users\ravon? Or do you see only the /folders/myfolders/ area that the virtual Machine were the SAS University Edition version of SAS is running? Or something else?

Re: Creating Libname in SAS Studio

armoore — Thu, 14 May 2020 04:38:50 GMT

I have attached pictures of my view of the Server Files and Folders

Re: Creating Libname in SAS Studio

Kurt_Bremser — Thu, 14 May 2020 04:46:40 GMT

You use SAS on Demand for Academics, the "odaws" on the top of your directory tree is the clue. Your SAS does not run on your desktop, it runs in the AWS cloud. Files must be uploaded through SAS Studio.

Re: Creating Libname in SAS Studio

armoore — Thu, 14 May 2020 17:08:09 GMT

For my understanding, I will not be able to use a libname statement to create a library name in SAS Studio. Unless I manually upload it into SAS Studio?

Re: Creating Libname in SAS Studio

Tom — Thu, 14 May 2020 17:20:50 GMT

@armoore wrote:
For my understanding, I will not be able to use a libname statement to create a library name in SAS Studio. Unless I manually upload it into SAS Studio?

SAS/Studio is just a browser based user interface to SAS. SAS itself is running on some machine. So for SAS to access data (to read or write) then that machine needs to be able to access the location where the file exists.

Assuming that what you really mean is whether you can access a file that exists on your PC from your SAS session then YES you need to make the file available on the machine where SAS is running.

A libname statement is a piece of SAS code that you use to create a libref (1 to 8 character name) that points to the where the data lives. So you don't upload a LIBNAME statement. You type it into your program and run it. If you want to access data that is not currently on the machine where SAS is running then you need to do something to get SAS access to the data. There is an upload/download user interface in SAS/Studio. But you an use other tools to move the files. Or better just use a shared location that both your PC and the SAS server can access directly.

Re: Creating Libname in SAS Studio

Kurt_Bremser — Thu, 14 May 2020 17:46:29 GMT

You can of course use Studio to create a libname, we do that all the time. But it has to point to a location that the SAS session can "see". Since your SAS runs on the amazon cloud (and this also means a Linux system), you need to put existing files into the Linux filesystem, and point statements for files you intend to create to a place that exists and where you may write.

I would expect that the introduction to your practices would cover all these things.

Re: Creating Libname in SAS Studio

fpb1 — Mon, 30 Aug 2021 14:04:58 GMT

Wow, I just lost 2 hours on this very issue, after following the advice of the Little SAS Book: "SAS in insensitive to case so you can use uppercase, lowercase, or mixed case - whichever looks best to you". Clearly not a valid general statement.

Re: Creating Libname in SAS Studio

Tom — Mon, 30 Aug 2021 14:16:27 GMT

Referencing SAS variables and other objects in SAS code is case insensitive. SAS does not care if your code use Name, NAME, nAME there is only one variable that it can match.

But your operating system, in this case unix, has its own rules that you also need to understand.

Re: Creating Libname in SAS Studio

Kurt_Bremser — Mon, 30 Aug 2021 17:41:53 GMT

Rule of thumb: anything between quotes needs to be treated as case sensitive.