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" ... View more

Is there a way to use virutal environments in the Open Source Code node? We have anaconda installed, but will likely need to install some additional packages down the line. I would really prefer using virtual environments in stead of doing installs and updates on a single anaconda installation. I guess we could alternatively run  conda list --export > requirements.txt to as a way to save the current working environment before installing or updating something. But I would guess VENV would be a bit easier to roll back if something goes wrong. Is there some best practice for this in the Model Studio context?       ... View more

I have created a score code in Model Studio in SAS VIYA and saved it to /My Folder/Test SAS score code.sas. I want to score a dataset using this score code, from SAS studio in VIYA.  In our old 9.4 enviroment, the following code works (EDIT: I did not work afterall, I overlooked an error): data mycas.scored; set mycas.to_score; %include "E:\somepath\sascode.sas"; run; In Viya, I have tried the following: data mycas.scored; set mycas.to_score; %include "/My Folder/Test SAS score code.sas"; run; But I can't find a way to specify the file path, and get the following errors:      WARNING: Physical file does not exist, /My Folder/Test SAS score code.sas.      ERROR: Cannot open %INCLUDE file /My Folder/Test SAS score code.sas. Have tried finding some sort of path in enviroment manager with no luck. How are filepaths specified in VIYA so that the file can ble included? I tried copy pasting the contents of the scorecode file, but that does not work, neither on 9.4. or VIYA. The score code look something like this: * This score code file references one or more analytic stores that are located in the caslib "Models". * This score code file references the following analytic-store tables: * _123456789awrsadf_ast */ data sasep.out; dcl package score ...;      ... View more

The last few years I have seen several options for integrating pyhton and SAS. These include: Calling SAS from python installed on a local machine or virtual machine, using IOM\SASpy Executing python code from SAS using proc FCMP SWAT to connect to CAS in i VIYA environment Groovy I have been using some saspy, as well as just using SAS to prep data, and read the sas files into python directly or through csv. But in this case, I have a local python installation. This works well for ad hoc task, as I can be quite self sufficient in installing and managing packages. If we were to use python in production, and not just for ad hoc analysis or visualizations, the setup would have to be different (with python installed on the SAS server, or something to that effect). This could allow for using python in production, running code in batch or on request from an application. But in that case, the end user would not be able to install a python package at their own leisure I would assume. Unless there is some container sollution.     I can't find a good overview of all the options, including how the different setups look on the server side. Roughly I have the impression that we could either go for local python, with flexibility and no good options for running python in a production settting, or installing python on a VIYA server, where someone with server access would have to manage packages and make sure nothing breaks. Am I missing somehting? And do you know any good overview of all these options for integrating python with SAS? ... View more