topic Re: How to create a job (Stored Procedure) in SAS VA 8.3 in SAS Visual Analytics

How to create a job (Stored Procedure) in SAS VA 8.3

mahimadhingra — Wed, 27 Mar 2019 11:17:10 GMT

Hi,

Please help in answering following questions:

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

Re: How to create a job (Stored Procedure) in SAS VA 8.3

Kalind_Patel — Wed, 27 Mar 2019 12:48:52 GMT

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=n1llg291lloyf8n129xq01re6bdf.htm&locale=en

Re: How to create a job (Stored Procedure) in SAS VA 8.3

ankush2301 — Thu, 28 Mar 2019 08:09:41 GMT

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

Re: How to create a job (Stored Procedure) in SAS VA 8.3

Kalind_Patel — Thu, 28 Mar 2019 09:38:42 GMT

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

Creating a Jobs:

https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=n1l0yij8rjbjqcn187q0tifuyab1.htm&docsetVersion=2.0&locale=en#

Samples:

https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=n0t91q5lsc2b8qn14fd0cgbmylr8.htm&docsetVersion=2.0&locale=en#

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.