topic Re: X Commands in SAS Viya Studio in SAS Viya

X Commands in SAS Viya Studio

USP2405 — Mon, 30 Oct 2023 09:55:42 GMT

I have SAS legacy code which is migrated to SAS Viya. In the code ,there are some X-commands which does not execute in SAS Viya. How do I run my x-commands in Viya Studio.

Example -

x "rm /data/sas/xplo/abc2405kjh.csv";

Re: X Commands in SAS Viya Studio

sbxkoenk — Mon, 30 Oct 2023 10:02:02 GMT

Hello,

You probably have NOXCMD as an option.

Check the log after submitting this:

proc options option=xcmd; run;

But for the operating system command 'rm', you can use the SAS FDELETE function instead!

The FDELETE function allows us to delete directories or files directly controlled by SAS.

Koen

Re: X Commands in SAS Viya Studio

USP2405 — Mon, 30 Oct 2023 10:11:36 GMT

Thank you for the solution.

But there are few more commands like rm, rm -f , cp (copying file from one path to another path).

I will try this option. Hope it will work.

Re: X Commands in SAS Viya Studio

sbxkoenk — Mon, 30 Oct 2023 10:17:30 GMT

Hello,

SAS has many of these functions prefixed with 'f' for dealing with external files.

fdelete
fexist
fileexist
fopen
fclose
fcopy
fappend
...

BR, Koen

Re: X Commands in SAS Viya Studio

USP2405 — Mon, 30 Oct 2023 10:27:54 GMT

Good to know these commands.

Our files are on unix and we have x commands for that.

Could you please tell me how these SAS function will work for this x command example.
x "rm /data/sas/xplo/abc2405kjh.csv";

Re: X Commands in SAS Viya Studio

USP2405 — Mon, 30 Oct 2023 11:08:26 GMT

Also these SAS functions are not supported in a DATA step that runs in CAS. Then we can not run these in SAS VIYA.

Re: X Commands in SAS Viya Studio

Kurt_Bremser — Mon, 30 Oct 2023 11:23:09 GMT

data _null_;
rc = filename(fref,"/data/sas/xplo/abc2405kjh.csv");
rc = fdelete(fref);
rc = filename(fref);
run;

Also see the documentation of the FDELETE Function. The other file handling functions are found right next to it.

Re: X Commands in SAS Viya Studio

LinusH — Mon, 30 Oct 2023 11:42:56 GMT

My understanding is that if you have non-CAS eligible statements/functions, the data step will execute in SPRE (SAS Compute), which is also part of Viya.

Re: X Commands in SAS Viya Studio

USP2405 — Mon, 30 Oct 2023 11:54:40 GMT

What if i need to execute x commands in SAS Viya?

Re: X Commands in SAS Viya Studio

Kurt_Bremser — Mon, 30 Oct 2023 12:30:19 GMT

Just as with SAS 9.4, XCMD must be enabled.

Re: X Commands in SAS Viya Studio

EdoardoRiva — Mon, 30 Oct 2023 12:45:58 GMT

Have you seen this page in the official documentation?

https://go.documentation.sas.com/doc/en/sasadmincdc/v_045/calcontexts/n1hjn8eobk5pyhn1wg3ja0drdl6h.htm#n0vaodiuepq6inn1n0dd3naghxur

That's something that a SAS Admin has to do, not an individual user.

Re: X Commands in SAS Viya Studio

Sajid01 — Fri, 17 Nov 2023 20:45:41 GMT

Hello @USP2405
The SAS Viya Administrator can enable XCMD in the SAS Environment manager for SAS Studio V.
This link shows step by step how to enable XCMD in environment Manager. The method works.
https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-3-5-SAS-Studio-and-SAS-Compute-Server-non-functional/ta-p/616617