SAS Stored Process in SAS Viya Visual Analytics

[adupendse26]

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.

[LinusH]

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

[JuanS_OCS]

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-J... Which explains a great alternative to Stored Processes, and if you go to the documentation you will see an example for file uploads 🙂

[kaiyuzhu]

@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

[FredrikE]

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

[Vince_SAS]

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...

Vince DelGobbo

SAS R&D