Hello All! We have an existing SAS solution that is based on SAS 9.3 (could be SAS 9.4). We've created a client-server application where the client is a .NET application and SAS acts as the processing server. We use SAS Integration Technologies (IOM) to have C# talk to SAS. In order to submit code, we simply use the language service to invoke existing SAS Macros. This has proven to be quite efficient and this is a technique we have used with success for several applications since 2009. With the introduction of SAS Viya, we're trying to see if we could migrate to this new platform. As such, we have began to explore the REST API of Viya. We were expecting differences but I have to be honest that I never thought that it would be so much different. My question is basically a 3 part question: 1. How can we use the SAS Viya REST API to invoke SAS Macro Code? I realize that Viya is not suited to submit SAS Macro code but in order to salvage as much code as possible, we would like to invoke our macro on the workspace server on Viya to then adapt the data steps and some of the procs to leverage the CAS processing. 2. How can we retrieve data from SAS Viya REST API? We want to get data from existing SAS datasets to show some of this content to our users on our GUI. Right now, we using the OLE connection that we can derive from the IOM Workspace server. 3. Is it possible to have progress report on long processes from the SAS Viya REST API. Right now, we use features from SAS itself where a command line called SYSECHO triggers an event into the IOM client. We can even send SYSECHO command from within the DATA STEP using DOSUBL. I realize that we may not be able to have all of this from the new API but anything we could suggest could help. One other question : we know SAS Viya can be accessed through SAS Enterprise Guide. When this is done, it the connection to SAS Viya done through the IOM client or has a completely new channel been added to SASEG where SASEG now invokes the REST API. I'm asking because if we have a case where going through SAS EG means going through IOM to talk to Viya, then this might be the simplest solution for us. Thanks!
... View more