BookmarkSubscribeRSS Feed
mahimadhingra
Calcite | Level 5

Hi,

 

Please help in answering following questions:

 

  1. Is it possible to create jobs (Stored procedures) in SAS VIYA and trigger these jobs from SAS Visual Analytics 8.3? These jobs include various SAS procedures & data step functionality.
  2. Can we create a stored procedure or macro button in SAS VA  which can trigger execution of a SAS code written in SAS Develop SAS Code Module in SAS Viya and also can we trigger execution of models in SAS VF from SAS VA ?
  3. Do we have an excel plugin/add-in for SAS VA 8.3? (Using Excel plugin we can open and edit the SAS dataset)

Please note we are working on SAS VA 8.3 version. Urgent help will be appreciated.

 

Thanks in advance !

Mahima

3 REPLIES 3
Kalind_Patel
Lapis Lazuli | Level 10
About question 1&2,
There's no stored process servers in SAS Viya,

But, In Viya you have Job exection which is bit identical to stored process.

You do not get the prompts, but you can create your own form which can pass parameters to the job.

Some referral link for you:

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

About question 3,
Yes you have SAS add-in for MS Office,
Here's a link for more information:
https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=whatsdiff&docsetTarget=n1...
ankush2301
Calcite | Level 5

hi Kalind Patel,

 

Thanks for your prompt reply.

 

Can you please suggest how can we create jobs and execute them in SAS VIYA. Do we need additional functionality for this?

 

As I see we should have web form functionality for jobs creation and which involves HTML + SAS coding. M I right in my understanding?

 

Thanks

Ankush

Kalind_Patel
Lapis Lazuli | Level 10

For developing Jobs and some sample codes, these links might help you:

 

Creating a Jobs:

https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=n1l0yij8rjbjqcn187q0tifuyab1.htm&docs...

 

Samples:

https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=n0t91q5lsc2b8qn14fd0cgbmylr8.htm&docs...

 

For Executing the SAS Jobs same like SAS Stored Process in SAS VA 8.3, you can use Web Content Object in Reports and specify SASJobExecution URL with parameters.

 


About your second question, yes you can use SAS Codes and HTML coding to generate an output in HTML.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 3416 views
  • 1 like
  • 3 in conversation