topic Re: connecting to a 9.4 libname from sas Viya in SAS Programming

connecting to a 9.4 libname from sas Viya

Ullsokk — Wed, 02 Sep 2020 08:51:15 GMT

How can assign a library that is on a 9.4 server in sas viya?

At the moment it seems I can either

Do a point and click import from Manage Data
Upload the data from sas studio on 9.4. using proc casutil

But none of the above lets me upload data from Viya to CAS in a SAS program, which is what I need. I want to set up a schedules program in Viya that uploads a dataset from a 9.4 libname on another server to CAS. E.g. the code that actually runs in the background when I upload the data from Manage Data.

Trying to assign the libname as normal does not work, I get a message saying the library does not exist.

libname nine4 "//someserver/somefolder"

Re: connecting to a 9.4 libname from sas Viya

ChrisNZ — Thu, 03 Sep 2020 01:38:31 GMT

This

//someserver/somefolder

is not a valid unix path (or Windows path for that matter).

You might want to try

"smb://someserver/somefolder"

Re: connecting to a 9.4 libname from sas Viya

Ullsokk — Thu, 03 Sep 2020 08:45:18 GMT

Well, the code\path works on in sas studio 9.4, for a folder on a windows server (no :// ) .
I guess what I am really wondering is what is the code equivalent to point and click data import of "local" files. And by "local" I mean files on another server.

Re: connecting to a 9.4 libname from sas Viya

SASKiwi — Thu, 03 Sep 2020 23:18:09 GMT

@Ullsokk - If your Viya server runs on linux (most common) and you are pointing to a Windows SAS 4 library it isn't likely to work because of OS differences and / or the linux server not having a folder share with your Windows server.

BTW @ChrisNZ is correct. On Windows your path should be specified with back slashes: \\MyServer\MyFolder.

Re: connecting to a 9.4 libname from sas Viya

ChrisNZ — Fri, 04 Sep 2020 01:12:17 GMT

The samba protocol is what's used in linux to reference UNC paths. Of course, feel free to ask questions and disregard answers. 🙂

Re: connecting to a 9.4 libname from sas Viya

Ullsokk — Mon, 07 Sep 2020 08:32:06 GMT

Backslashes work, as do slashes, probably due to language settings (Norwegian). In any case, now see that the linux server needs to have a folder share for the libname-approach to work