Transfer text files from remote SFTP sever to local linux server

[gyambqt]

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;

[Kurt_Bremser]

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.