Hi there, I'm new to SAS and I need to export or some excel file on a remote server using sftp. Currently I use the following command to create the files on a shared drive! PROC EXPORT DATA = Final_data OUTFILE= "\\testfolder\DailyReport.xls" DBMS=EXCEL REPLACE LABEL; SHEET="Data"; RUN; However the new approach is using sftp for the security purposes. My first question is, is it possible to use sftp to create files on the remote server? If not, I'm thinking of creating files on local server and move them using sftp to the destination server. So my second question is what is the command to transfer all files of one folder to the destination server using sftp and private key. Thanks!
... View more