topic Re: system command is not working in EG in New SAS User

system command is not working in EG

hhhhh — Thu, 22 Nov 2018 13:35:39 GMT

Hi All,

when I am executing below code in sas 9.4 its working fine, but when same code I am trying to execute in sas EG, its just keep on running. Can anyone suggest me what is going wrong here?

Many thanks in advance...

data _null_ ;
* VERIFY PSFTP Success and report out;

rc=system("&LabDM_path\PuTTY\psftp &YYY@&ZZZ -b &LabDM_path\&DT_partl_path\&BAT..scr") ;

put rc;
if rc = 0 then Posting = datetime() ;
else Posting = .F; *<<---means file failed;
put Posting= datetime20. ;
run ;

Re: system command is not working in EG

RW9 — Thu, 22 Nov 2018 13:54:18 GMT

I would check that your system admin allows you to use operating commands from SAS first. If so, then we would need to see what is exactly being done. Open a command prompt and paste the actual command in there and run it. Could hundreds of different things from access, to connection, to network drives, different operating system, etc. I mean, just to start with your code, what does:

rc=system("&LabDM_path\PuTTY\psftp &YYY@&ZZZ -b &LabDM_path\&DT_partl_path\&BAT..scr") ;

Do, what does it resolve too? We cannot guess these things.

Re: system command is not working in EG

hhhhh — Thu, 22 Nov 2018 15:26:26 GMT

Dear,

Many thanks for quick response. Below is the the explaination of given code-

rc=system("\\quintiles.net\Enterprise\Organization\GDM\LabDM\General\PuTTY\psftp &YYY@&ZZZ -b \\quintiles.net\Enterprise\Organization\GDM\LabDM\General\Hemant\sftp\Export\BAT.scr")

Also does this restriction from Windows or SAS EG?

Please let me know if you need more input from me.

Re: system command is not working in EG

SuryaKiran — Thu, 22 Nov 2018 15:40:07 GMT

Hi,

1) How is the connection in SAS EG, is it connected to server or local?

2) You have macros referenced, are they available in EG?

Re: system command is not working in EG

hhhhh — Thu, 22 Nov 2018 15:44:27 GMT

Hi Suryakiran,
1) it is connected to server.
2) yes, they are available in EG.

Kind Regards,
Hemant

Re: system command is not working in EG

RW9 — Thu, 22 Nov 2018 15:53:00 GMT

The restriction is set in EG as part of the options. If that is enabled then set your command as a pipe and feedback the response from it:

filename tmp pipe "...";

data test;
  length buff $200;
  infile tmp;
  input buff $;
run;

In this way test will hold all the feedback from the operating system on what is happening. It can be a lot of different things.

Re: system command is not working in EG

r_behata — Thu, 22 Nov 2018 16:17:18 GMT

Ensure that the X Commands options (which enable execution of the OS commands) is enabled in your environment.

Perhaps this link could help you.

http://support.sas.com/kb/41/058.html

Re: system command is not working in EG

Kurt_Bremser — Fri, 23 Nov 2018 06:52:20 GMT

@hhhhh wrote:
Hi Suryakiran,
1) it is connected to server.
2) yes, they are available in EG.

Kind Regards,
Hemant

Which most probably means that your SAS 9.4 runs locally on your desktop, while EG uses a remote server. DO NOT assume that the environment of the server is the same as that on your desktop.

First verify that the system command you want to run works directly from the commandline, best from a remote login to the server.

Once that is done and it works, run the system command from SAS with the filename pipe method to catch all system responses (don't forget to add 2>&1 at the end of the command to reroute stderr output to the pipe).

Re: system command is not working in EG

hhhhh — Tue, 27 Nov 2018 21:15:08 GMT

Dear Kurt,

Yes, I am able to execute same command from cmd ,its working fine. How can I make it run using my program in EG?

Many thanks in advance.

-Hemant

Re: system command is not working in EG

Kurt_Bremser — Tue, 27 Nov 2018 21:44:58 GMT

Use the filename pipe method to catch all system responses.