topic Re: What's the best way to automate tasks in SAS Studio? in Developers

What's the best way to automate tasks in SAS Studio?

a20121248 — Thu, 25 May 2023 19:51:56 GMT

Hi experts:

I have Viya 3.5. I need a way to orchestrate these tasks:

pull from a Git remote repo
create a Job definition
execute the Job
publish a registered model in Model Manager

My approach was to consume the SAS Rest API (https://developer.sas.com/guides/rest.html), though I'm not sure if the right approach because I have to format "proc http response" from SAS Studio, for example:

I want to ask 2 questions:

Is it possible to get the access_token from my SAS Studio Logged session? or is it possible to call SAS Rest API from SAS Studio since I'm already authenticated (bypass access_token parameter)?
Is there another way to create Jobs, Publish Models from code without using API?

I am open to all suggestions. Thanks in advance.

Re: What's the best way to automate tasks in SAS Studio?

AhmedAl_Attar — Thu, 25 May 2023 18:17:18 GMT

Hi @a20121248

Talk to the folks at SASJs.io

They have a macro for that 😉 (getting App Token, that is)

In terms Orchestration/Automation within SAS Studio, it all depends on which version of Viya/SAS Studio you are using!

There are various versions of SAS Studio and they vary in their features and functionalities.

https://support.sas.com/software/products/sas-studio/faq/SASStudio_releases.htm

https://support.sas.com/software/products/sas-studio/faq/whatsnew.htm

Hope this helps

Re: What's the best way to automate tasks in SAS Studio?

AhmedAl_Attar — Thu, 25 May 2023 18:21:02 GMT

@AllanBowe
Do you have bandwidth to chime in?

Re: What's the best way to automate tasks in SAS Studio?

AllanBowe — Thu, 25 May 2023 18:39:40 GMT

Personally, I wouldn't do this in Studio, I'd write a shell script instead

```

# first, set up the authentication using sasjs auth with client/secret pair

cd myrepo # move into project

git pull # grab source code

sasjs cbd # compile, build & deploy my job(s)

sasjs job execute /path/to/my/job -l /local/path/to/my.log

```

If you must use SAS code, in Studio (Viya) you don't actually need an access token as you can use the oauthbearer=sas_services proc http option.

In this case you can use the git_clone and git_pull SAS functions to clone the repo.

Then, this macro to create the job(s): https://core.sasjs.io/mv__createjob_8sas.html

And this macro to run them: https://core.sasjs.io/mv__jobflow_8sas.html

We don't work much with Model Manager (our main focus is cross-platform SAS apps and related modernisations) but available to support if needed.

Re: What's the best way to automate tasks in SAS Studio?

joeFurbee — Fri, 26 May 2023 17:48:17 GMT

Hi @a20121248,

You can also take a look at some of @Mike_Drutar's Community articles on Job Execution. For example, Executing a JES Job Using JavaScript. He has several others posted and they're super easy to follow.