BookmarkSubscribeRSS Feed
smehae
SAS Employee

Dears,

 

We want to build SAS DI Job that are exposed to return different output tables and the DI job will be exposed as web service ... currently DI job exposed as output service can have only one output file .. how we can include multiple different tables in the response of exposed web service ?

 

We are using SAS9.4 Platform.

3 REPLIES 3
rudfaden
Pyrite | Level 9

Think you are using the wrong tool. I suggest you use a SAS Stored Process instead.

LinusH
Tourmaline | Level 20

If you happen to licence Enterprise Decision Management with a MAS server component, there's a transformation for that:

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

Haven't tested it myself though.

 

You can also deploy a DI Stdio job as a SAS Stored Process. It's not like a modern service, but similar:

SAS Help Center: About Deploying Jobs as Stored Processes

 

A Stored process can then be published as a web service:

SAS Help Center: About Deploying Jobs as Web Services

Data never sleeps
rudfaden
Pyrite | Level 9

Maybe you should tjek out https://sasjs.io/. They made a framework for web development with SAS

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 817 views
  • 0 likes
  • 3 in conversation