BookmarkSubscribeRSS Feed
Ullsokk
Pyrite | Level 9

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"
5 REPLIES 5
ChrisNZ
Tourmaline | Level 20

This

//someserver/somefolder

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

You might want to try 

 

"smb://someserver/somefolder"

 

 

Ullsokk
Pyrite | Level 9
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.


SASKiwi
PROC Star

@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.

Ullsokk
Pyrite | Level 9
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
ChrisNZ
Tourmaline | Level 20

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

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1435 views
  • 0 likes
  • 3 in conversation