Hi, I need to develop a SAS program to get a file from an remote SFTP server and rename the file after download the file. I can get the file but don't know how to send the UNIX rename command to the remote SFTP server to rename the file. Any suggestion? Following is my code that I have developed and it works well: Filename SITE1 SFTP "reports/Market_Summary_date..csv" Host="142.199.199.199" user="user1" ; data WORK.Market_DATA ; %let _EFIERR_ = 0; infile site1 delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2; informat REPORT_DATE yymmdd10. ; format REPORT_DATE yymmdd10. ; input REPORT_DATE; if _ERROR_ then call symputx('_EFIERR_',1); run;
... View more