Transfer text files from remote SFTP sever to local linux server

gyambqt — Wed, 09 Aug 2023 01:32:11 GMT

Hi Experts,

I am willing to transfer files from a remote SFTP server to local linux server and my command is below:

Is there any problem with my code below as an example?

method1:

%let ftpcmd = "sftp -i path of SSHKEY username@sftpserverdetail:/sftppath/file.csv /localpath/file.csv";
filename ftppipe pipe &ftpcmd.;

data _null_;
infile ftppipe;
input;
put _infile_;
run;

method2:

%let ftpcmd = "scp username@sftpserverdetail:/remotesftppath/file.csv /localpath/file.csv";
filename ftppipe pipe &ftpcmd.;

data _null_;
infile ftppipe;
input;
put _infile_;
run;

Re: Transfer text files from remote SFTP sever to local linux server

Kurt_Bremser — Wed, 09 Aug 2023 07:34:58 GMT

Add "2>&1" to your commands, like

"sftp -i path of SSHKEY username@sftpserverdetail:/sftppath/file.csv /localpath/file.csv 2>&1"

This will reroute stderr to stdout, so you can catch diagnostic messages in the DATA step. After that, run your code and read the log.