topic upload a table from SAS Data Integration Studio to SAS Viya in SAS Viya

upload a table from SAS Data Integration Studio to SAS Viya

touwen_k — Fri, 12 Jul 2024 14:59:00 GMT

hello SAS Community, I have SAS 9.4 M8 and authenticated as custom app to SAS Viya so that I can make a cas session. That part goes well now. What is the example code how to upload a table from SAS Data Integration Studio in SAS 9.4 to SAS Viya? Pls advise it would be great to have this option.

Re: upload a table from SAS Data Integration Studio to SAS Viya

SASKiwi — Fri, 12 Jul 2024 23:14:03 GMT

The best option I can think of is SAS/CONNECT. Viya includes SAS/CONNECT. but it comes as an add-on to SAS 9.4. With SAS/CONNECT you can use the PROC UPLOAD and PROC DOWNLOAD to move SAS data between SAS 9.4 and Viya. You can even remotely submit code from SAS 9.4 to Viya. To check if you have SAS/CONNECT installed and licensed in SAS 9.4 run this:

proc product_status;
run;

proc setinit;
run;

Re: upload a table from SAS Data Integration Studio to SAS Viya

LinusH — Sun, 14 Jul 2024 20:04:31 GMT

https://documentation.sas.com/doc/sv/etlug/4.905/p0k42wyoble1hkn17mumd71syeej.htm

Re: upload a table from SAS Data Integration Studio to SAS Viya

touwen_k — Mon, 15 Jul 2024 15:18:48 GMT

Thank you for your answer