export to SFTP

[GabrielGajardo]

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. 

to 

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.

[Kurt_Bremser]

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

[Patrick]

@GabrielGajardo

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

Link edited by @Kurt_Bremser