Hello All,
I am currently using SAS DI and Scheduled all my jobs in SAS Management Console
Now I am migrating in to SAS VIYA 9.4
Can anyone know how can i migrate SAS DI Scheduler flow in SAS VIYA
Also run all jobs and load data in sas viya.
Thanks
Jignesh Patel
Hi Alexal
It looks like SAS VIYA has its own schedule manager where we schedule jobs.
Also, By using SAS Viya Studio we can schedule program by using snippets functionality.
I will work upon on both option.
But is their other option in which we import SAS DI Jobs directly as SPK Package ?
Thanks
Jignesh Patel
Hi LinusH,
Thanks a lot for your reply. So till now there will be no bridge directly between in SAS Di and SAS Viya.
If I want to run SAS DI codes in SAS Viya then can you tell me which type of major changes require from server / connection side ?
Thanks
Jignesh Patel
I don't think it makes sense to "execute" the code in Viya unless you have severe performance issues as of now.
But there are transformations available in DI Studio (later versions) that lets you connect to Viya, upload data, and send steps for processing.
If you are using a version older then M5, you'll have to use SAS/CONNECT.
Hi @JIGNESH ,
The main thing you need is to configure connect between sas 9.4 and SAS Viya.
/opt/sas/viya/config/etc/SASSecurityCertificateFramework/cacerts
I am using DI 4.903 and as @LinusH mentioned it has the special transformation for loading tables into CAS (SAS Viya).
This link helped me a lot https://communities.sas.com/t5/SAS-Communities-Library/CAS-and-SAS-Data-Integration-Studio-4-903-on-...
Note: that you will need to create authinfo file
Also, I created the custom script that I am using for loading table into CAS (you can also run it EG)
%macro mLoadTableToCAS (mvSASLibname=,mvTableName=, mvTableNameInCAS=, mvCasLibname=);
%macro dummy; %mend dummy;
/* Create CAS session */
cas CASAUTO host="<cas server hostname>" port=5570;
LIBNAME CASRDBP CAS CASLIB=&mvCasLibname PORT=5570 SERVER="<cas server hostname>" ;
%let checkExist=%eval(%sysfunc(exist(CASRDBP.&mvTableNameInCAS, DATA)));
%if (&checkExist) %then %do;
/* Replace target table requested: Drop session table */
proc casutil sessref=&_SESSREF_.;
droptable casdata="&mvTableNameInCAS." incaslib="&mvCasLibname" quiet;
quit;
/* Replace target table requested: Drop global table */
proc casutil sessref=&_SESSREF_.;
droptable casdata="&mvTableNameInCAS." incaslib="&mvCasLibname" quiet;
quit;
%end;
/* PROC CASUTIL: LOAD DATA */
proc casutil outcaslib="&mvCasLibname" sessref=&_SESSREF_.;
load data=&mvSASLibname..&mvTableName casout="&mvTableNameInCAS."
promote;
quit;
/* Terminate CAS session */
cas CASAUTO terminate;
%mend mLoadTableToCAS;
libname SASLIB '<path>'; /*Please specify libname statement*/
%let mpSaslib=SASLIB;
%let mpCaslib=Public;/*specify CAS library name where you want to load data. By default Public*/
%let mpTableName=<table_name>; /*Please specify table name.*/
%mLoadTableToCAS(
mvSASLibname=&mpSaslib,
mvTableName=&mpTableName,
mvTableNameInCAS=&mpTableName,
mvCasLibname=&mpCaslib);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!