topic Re: Operation method using powershell in SAS Viya

Operation method using powershell

kzysmt — Thu, 21 Apr 2022 02:44:48 GMT

I want to run a SAS program using sas studio on viya using powershell.
Please tell me the pages and methods that will be helpful.

Re: Operation method using powershell

kzysmt — Thu, 21 Apr 2022 05:05:11 GMT

It doesn't matter if it's not a shell.
I would like to run a SAS program in Viya in some way.

Re: Operation method using powershell

AllanBowe — Thu, 21 Apr 2022 08:42:59 GMT

You can run a SAS program on SPRE using the SASjs CLI.

Installation instructions: https://cli.sasjs.io/installation/
Configure your SAS target: https://cli.sasjs.io/add/
Run some code: https://cli.sasjs.io/run/

Here's a video demo of the above on Viya 4: https://communities.sas.com/t5/SAS-Hacker-s-Hub/Hacker-tip-2-running-SAS-code-from-terminal/td-p/800130

Re: Operation method using powershell

gwootton — Thu, 21 Apr 2022 12:38:49 GMT

It's unclear to me what you want to do here.
SAS Studio is a web application, so if you were running a SAS program using SAS Studio you would not be using PowerShell.
You then say it doesn't matter if it's not a shell, you'd just like to run a SAS program in Viya, and SAS Studio would be a way to do this.
If your goal is to execute some SAS program in Viya non-interactively, you can store the program in Viya and schedule it to run or call the Job Execution REST API to run it (which could be done from anything that can send HTTP, including PowerShell).

Documentation on the Job Execution REST API can be found here:

https://developer.sas.com/apis/rest/v3.5/Compute/#job-execution

Re: Operation method using powershell

kzysmt — Fri, 22 Apr 2022 05:43:24 GMT

thank you for your reply.

As you said, I want to upload the SAS program files to sas studio on viya.

It seems that I can upload xlsx, csv, etc. to CAS using the following command, but I don't know how to upload the SAS program.

Do you know how to upload a SAS program file using the CLI?

sas-admin cas tables import

Re: Operation method using powershell

gwootton — Fri, 22 Apr 2022 13:51:19 GMT

I don't see a plugin in sas-admin CLI that can upload a file to the files service, so you'd need to use the files service REST API as described here:

https://developer.sas.com/apis/rest/v3.5/CoreServices/#create-new-file-resource

Re: Operation method using powershell

AllanBowe — Fri, 22 Apr 2022 14:54:31 GMT

You can deploy SAS programs as Jobs (accessible in SAS Drive) using the SASjs CLI: https://cli.sasjs.io/deploy

We have an open issue for including Studio programs: https://github.com/sasjs/cli/issues/991

If your project has the budget to support this feature, we'd be happy to build it.