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.
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 🙂
@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
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:
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.