topic Re: SAS Stored Process in SAS Viya Visual Analytics in SAS Visual Analytics

SAS Stored Process in SAS Viya Visual Analytics

adupendse26 — Mon, 18 Mar 2019 15:06:55 GMT

Hello Experts,

I am currently working on SAS Viya 3.4 Visual Analytics and I would like to use stored process component in SAS Viya Visual Analytics 8.3, is it possible?

Can someone please help and possibly provide any example which would provide more clarification on Stored Process.

Alternatively, Is there any other way to showcase manual file upload functionality in SAS Viya Visual Analytics 8.3.

Re: SAS Stored Process in SAS Viya Visual Analytics

LinusH — Mon, 18 Mar 2019 15:17:39 GMT

AFAIK there is no Stored Process server at all in Viya.

But here is a link on how to access a 9.4 Stored Process server from Viya:

http://support.sas.com/kb/60/738.html

Re: SAS Stored Process in SAS Viya Visual Analytics

JuanS_OCS — Mon, 18 Mar 2019 15:19:06 GMT

Hello @adupendse26 ,

If you have a SAS 9.4 environment, you could make a call from SAS VA 8.3 to the Stored processes that are in SAS 9.4. SAS Viya does not offer SAS Stored Processes but it can use STPs from SAS 9.4. See http://support.sas.com/kb/60/738.html

You might want to read this post: https://communities.sas.com/t5/Nordic-Events-and-Presentations/SAS-Forum-Copenhagen-2019-Using-SAS-Job-Execution-Services-in/ba-p/543063?nobounce Which explains a great alternative to Stored Processes, and if you go to the documentation you will see an example for file uploads 🙂

Re: SAS Stored Process in SAS Viya Visual Analytics

FredrikE — Mon, 18 Mar 2019 15:59:47 GMT

Hi!

In Viya you have Job exection which is similiar to stored process.

You don't get the prompting framework, but you can create your own form that passes parameters to the job.

This might get you started:

https://documentation.sas.com/api/docsets/jobexecug/2.0/content/jobexecug.pdf?locale=en

//Fredrik

Re: SAS Stored Process in SAS Viya Visual Analytics

kaiyuzhu — Thu, 22 Aug 2019 21:58:25 GMT

@JuanS_OCS Thank you for your post. I'm trying the alternative to Stored Processes that you mentioned in SAS Viya 3.4. Here is my situation, I have a very big dataset which contains over 200 millions rows, it has all the detail data which user can drill down from a high level. The problem is loading all the data into my memory is too big.. So I'm trying to use SAS Job execution web application to implement a real-time select statement to my Hive database to fetch the detail data when users clicks drill down. I don't find any people asking question on internet about SAS Job execution web application, and I don't see the part that I want to implement from the user guide neither. Could you please provide me a example on how to implement this? I assume not many people have implemented similar kind of function using SAS Job execution web application?. Thank you very much

Re: SAS Stored Process in SAS Viya Visual Analytics

Vince_SAS — Thu, 11 Jun 2020 19:46:48 GMT

You an use HTML forms to prompt for input in all versions. Prompts similar to what are available in SAS 9 are available in SAS Viya 3.5 and later.

SAS 9.4 and SAS Viya 3.5 Programming Documentation > SAS Job Execution Web Application
Samples > Prompts
https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=jobexecug&docsetTarget=n0t91q5lsc2b8qn14fd0cgbmylr8.htm#p034lojt1comj4n1xrp2dggcmh9h

Vince DelGobbo

SAS R&D