I am running below code but it fails with message “ERROR: Shell escape is not valid in this SAS session”. This code basically via SAS/Connect connects to remote host and run X command.
When I run the same command via workspace Server(i.e. via SAS EG on local host) the code works. What I understood is it is becasue Connect Server starts with -NOXCMD option.
I tried to make change from -NOXCMD to XCMD, by making changes in sasv9_usermods.cfg and ConnectServer_usermods.sh but nothing works.
PS: XCMD is working fine for workspace server in remote and local, also permission of file is correct. And Connect Server is working fine as TCP connection is happening.
LIBNAME ADM00 BASE "Data/ETLA-System_Administrasjon/ADM.00_Common";
Option NOCONNECTMETACONNECTION ;
%LET TCPHOST = dc4coj 7552;
options remote=TCPHOST comamid=tcp;
signon TCPHOST user=sasftp pass="XXXX";
command="df -g >/drift/logs/admin/ADM_DF_Disk_Usage_dc4coj.txt";
--> Startup Script for Connect Server:
/local/apps/SAS94/config/Lev1/SASETL/ConnectServer/ConnectServer.sh -DMR -COMAMID TCP -NOXCMD -NOTERMINAL
--> Changes in sasv9_usermods.cfg and ConnectServer_usermods.sh
$ cat ConnectServer_usermods.sh
# This script extends connectserver.sh. Add local environment variables
# to this file so they will be preserved.
USERMODS_OPTIONS=" -xcmd "
$ cat sasv9_usermods.cfg
Take a look at the connect spawner configuration in SAS metadata.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.