topic Re: local libnamOk Vince_sas. however, I can't load sas datasets locally. in sas Viya in SAS Viya

local libname in sas Viya

mariopellegrini — Wed, 24 Jun 2020 14:40:58 GMT

Goodmorning everyone.
I'm new to SAS Viya, maybe I ask a trivial thing but I can't find a solution.
I would simply like to upload a sas dataset from my pc locally.
In this video:
https://video.sas.com/detail/video/5334369476001/understanding-caslibs-and-loading-data-in-sas%C2%AE-viya%E2%84%A2
a sas library is set up very simply like this:

libname orion "c\mydata";

However from sas viya if I set up a library by putting a local path I get the answer that the library does not exist:

Re: local libname in sas Viya

Vince_SAS — Thu, 25 Jun 2020 01:55:57 GMT

The SAS executable is running on a server machine, not your local machine.

The LIBNAME statement referencing the path on your local machine fails because the server machine does not have access to your local machine.

Vince DelGobbo

SAS R&D

Re: local libnamOk Vince_sas. however, I can't load sas datasets locally. in sas Viya

mario_pelleg — Thu, 25 Jun 2020 09:14:07 GMT

Ok Vince_sas. however, Since it is possible to upload files locally through the following procedure, I thought it was also possible to do it from sas code. Is it possible?

Re: local libnamOk Vince_sas. however, I can't load sas datasets locally. in sas Viya

Vince_SAS — Thu, 25 Jun 2020 12:02:24 GMT

Are you presented with a Windows Open File dialog box during the import process? The Open File dialog box is able to navigate the file system on your local machine and then transfer the file to the server.

If your IT department hasn't provided you a way to access your local machine from the SAS Viya server machine, then there is no code SAS code that you can write to access the local file, except possibly the URL or FTP FILENAME access methods (or PROC HTTP).

Vince DelGobbo

SAS R&D

Re: local libnamOk Vince_sas. however, I can't load sas datasets locally. in sas Viya

mario_pelleg — Fri, 26 Jun 2020 07:46:35 GMT

My question at this point is:
what is the correct way to load a sas table present locally, on cas lib?

Re: local libnamOk Vince_sas. however, I can't load sas datasets locally. in sas Viya

Vince_SAS — Mon, 29 Jun 2020 16:00:16 GMT

SAS Studio in the video is accessing C:\, but it is C:\ on the server machine, not the local machine. One can deduce that the server is running on the Windows operating system. The code would fail if the server were running on a UNIX operating system.

You can use the visual interface to load data from your local machine. If you want to use code to load the data, then you need to move the data to the server machine, or contact your IT department to see what options they can provide to map a network drive that is accessible to the server machine.

Vince DelGobbo

SAS R&D