BookmarkSubscribeRSS Feed
mahimadhingra
Calcite | Level 5

Hi,

 

We are creating a tool in SAS Visual Analytics Version 8.3 which provides user the functionality to change the predicted values for 100 weeks for selected customer (example – “Customer A”) and selected product (example - “Product 123”) (selected via filters). We want to save user inputs at the backend table so that if user selects other customer (example – “Customer B”) and product (example - “Product 124”), old values are saved as well.

 

 Example details to develop this functionality in SAS Visual Analytics 8.3 is given below. Column H are parameters wherein users are giving inputs. Using those inputs, we are creating a formula in column K which requires dynamic referencing (basis number of combinations of Hier 3 & Hier 4). We want to replicate formula as shown in column ‘Final Pred’ which gets updated as per selected filter and user inputs.

 

SAS VA.JPG

 

Please suggest a way out or if any other way is possible to develop this functionality. Urgent help will be appreciated.

 

Thanks in advance !

Mahima

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

Hi!

Job execution might help you here and in your other post on the community, check this out:

https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=titlepage.htm&docsetVersion=2.0&local...

 

//Fredrik

ankush2301
Calcite | Level 5

Hi Fredrike,

 

Do you mean converting the above functionality into a sas code and convert it into a Job?  Also I want to understand how can i enable job creation process in existing SAS VIYA solution, as we do not see any job creation module . Does it require anything else then SAS Coding? like HTML or JAva coding?

 

Thanks in advance

Ankush

FredrikE
Rhodochrosite | Level 12

Hi!

It works more or less like the old stored processes. You write base code and create a package which can be run from viya and the interface.

You don't get the prompting framework but can create your own using standard web techniques like html and javascript.

 

To access the application type: 

http://host:port/SASJobExecution/

 

When you select create new you can choose to create code or form.

 

//Fredrik

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 698 views
  • 1 like
  • 3 in conversation