Hi All,
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.
Please suggest.
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.
--> Code:
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";
rsubmit TCPHOST;
data _null_;
command="df -g >/drift/logs/admin/ADM_DF_Disk_Usage_dc4coj.txt";
call system(command);
run;
endrsubmit;
signoff;
--> 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
#!/bin/sh -p
#
# 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
-xcmd