I am trying to upload or download a file from SFTP. The sas code that I use for the job is
options mlogic mprint obs=max formdlim='_' source2 noxsync noxwait source=1;
%let id=user;
%let pw=xxxxxx;
data null;
file 'F:\Batch\getDATA.bat'; * the batch file;
put "ftp -s:%0";
put "goto END";
put "open [email protected]"; /*Host name*/
put "&id";
put "&pw";
put 'CD "USer/Test/file"';/* FTP path*/
put "LCD C:\Users\dwnld";/* Local Destination path*/
put "GET abcd.txt";/* File name*/
put "bye";
put ":END";
run;
for FTP. This is not working for SFTP. Can you please suggest the same using batch file for SFTP. I have tried with file name options as well. That is not working too.