topic Re: Accessing two servers simultaneouslyn in from SAS EG 7.1 in SAS Programming

Accessing two servers simultaneouslyn in from SAS EG 7.1

arunrami — Fri, 23 Nov 2018 11:45:41 GMT

Hello Guys,

I wonder is there any possibility to run a SAS program against two different linux server at the same time? For Eg:- I have code which should read the file name in particular path from server X and Server Y and store it in to the data set library which resides in server X.

Please let me know if there any programmatic way or admin level solution to do that. Thanks!

Re: Accessing two servers simultaneouslyn in from SAS EG 7.1

Kurt_Bremser — Fri, 23 Nov 2018 12:09:15 GMT

So you want to create a list of files which are stored in separate paths on separate servers?

I'd try to read the directory listings with sftp, and later combine the results into one dataset:

filename sftpcmd pipe "echo 'ls *'|sftp -q user@server:/path";

data dir1;
infile sftpcmd;
length line $100;
input;
line = _infile_;
if substr(line,1,4) not in ('Conn','sftp') and substr(line,length(line)) ne '/';
run;

You need to have public/private key authentication, so you don't need a password.

Re: Accessing two servers simultaneouslyn in from SAS EG 7.1

arunrami — Mon, 26 Nov 2018 11:43:02 GMT

Hi Brem, Thanks for your response. But when I tried the below syntax you given I am getting an following error message, Could you please suggest me some way to overcome it ??

Note: Instead of user name - I given my username, and for server- given meta data server which we are going to access from different server, path- particular path from that server

ERROR: Insufficient authorization to access PIPE.
ERROR: Error in the FILENAME statement.

ERROR: No logical assign for filename SFTPCMD.

Re: Accessing two servers simultaneouslyn in from SAS EG 7.1

Kurt_Bremser — Mon, 26 Nov 2018 12:11:09 GMT

Which means that the default NOXCMD option is in place in your SAS server setup. So you either need to have that enabled by the SAS administrator, or find another way to connect to the servers. If all participating servers have SAS installed, and SAS/CONNECT licensed, you could use that, and the file functions from within SAS.