export to SFTP

GabrielGajardo — Tue, 26 Sep 2017 21:08:27 GMT

hi All,

I had a code that was working fine for a lot of time, but sudenly the receptor of the file changed his FTP conection to an SFTP one,

now i am getting an error.

bellow you can find my current code to export to FTP, it is on a macro that is in another macro.

rsubmit;
%macro export_to_ftp(dsn ,outfile_name, user, pass );

      Filename MyFTP ftp "&outfile_name." 
                                HOST='ftp.myhost.com'
                                cd= '/'
                        USER="&user."
                        PASS="&pass.";
      PROC EXPORT DATA= &dsn. 
      OUTFILE= MyFTP 
      DBMS=csv REPLACE;
      RUN; filename MyFTP clear;
%mend;

%export_to_ftp(dsn=folder.DataSetName ,outfile_name=my_file-&sysdate..csv, user = user, pass = pass);

endrsubmit;

i have tried to just change the line

Filename MyFTP ftp "&outfile_name.

Filename MyFTP sftp "&outfile_name."

but i am getting an error like :

ERROR 23-2: Invalid option name PASS.
ERROR: Error in the FILENAME statement.

Re: export to SFTP

Kurt_Bremser — Tue, 26 Sep 2017 21:27:27 GMT

Filename sftp requires that passwordless authentication (public/private key) has been established; therefore it does not have a password option.

Re: export to SFTP

Patrick — Wed, 27 Sep 2017 06:17:44 GMT

@GabrielGajardo

May be the following link will be of help: http://support.sas.com/kb/56/154.html

Link edited by @Kurt_Bremser

topic Re: export to SFTP in SAS Programming

export to SFTP

Re: export to SFTP

Re: export to SFTP