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-microsof... using SAS Viya 2022.x instead of SAS 9.4?
Thanks,
Eyal
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.
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.
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?
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.
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!