DATA Step, Macro, Functions and more

export to SFTP

Reply
Occasional Contributor
Posts: 6

export to SFTP

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.

Super User
Posts: 7,868

Re: export to SFTP

Posted in reply to GabrielGajardo

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Respected Advisor
Posts: 4,173

Re: export to SFTP

[ Edited ]
Posted in reply to GabrielGajardo

@GabrielGajardo

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

 

Link edited by @KurtBremser

 

Ask a Question
Discussion stats
  • 2 replies
  • 114 views
  • 2 likes
  • 3 in conversation