topic Re: Using SAS AMO to run STPs (or equivalent) in SAS Viya 2022.x? in SAS Viya

Using SAS AMO to run STPs (or equivalent) in SAS Viya 2022.x?

EyalGonen — Sun, 29 May 2022 11:37:58 GMT

Hi experts,

Does anyone know if one can achieve what is described here: https://video.sas.com/detail/videos/sas-add-in-for-microsoft-office/video/3862907101001/use-microsoft-excel-data-as-input-to-a-stored-process?autoStart=true&page=5 using SAS Viya 2022.x instead of SAS 9.4?

Thanks,

Eyal

Re: Using SAS AMO to run STPs (or equivalent) in SAS Viya 2022.x?

AllanBowe — Mon, 30 May 2022 00:01:10 GMT

One approach is to simply ingest the excel in a web app and send that to the backend for processing.

Here's a video of doing that on Viya using Data Controller for SAS: https://vimeo.com/417808409?embedded=true&source=video_title&owner=89559501 - in this, additional STPs (known as Jobs in Viya) can be triggered after approval.

If you wanted to build something similar yourself, you can make use of the same excel parser as we do: https://sheetjs.com/ and call Viya using SASjs: https://github.com/sasjs/adapter

Disclaimer - my team built both Data Controller and SASjs.

Re: Using SAS AMO to run STPs (or equivalent) in SAS Viya 2022.x?

EyalGonen — Mon, 30 May 2022 08:45:21 GMT

Thank you for the idea. My question was more basic than your proposed answer 🙂

I am asking whether technically it is possible to invoke SAS Viya jobs from Excel using SAS AMO like it is possible to invoke STPs from Excel with SAS 9.4?

Re: Using SAS AMO to run STPs (or equivalent) in SAS Viya 2022.x?

AllanBowe — Mon, 30 May 2022 08:50:01 GMT

SAS AMO is a SAS 9 product

You could set up a Stored Process to call Viya if you're running both. Or, use VBA to call the SAS Viya REST APIs.

Otherwise, you'll have to wait for the office support in Viya (might be out already) that brings connectivity to Office 365. Not sure about legacy excel though.