09-26-2017 05:08 PM
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.
09-26-2017 05:27 PM
Filename sftp requires that passwordless authentication (public/private key) has been established; therefore it does not have a password option.
09-26-2017 05:36 PM - last edited on 09-27-2017 02:17 AM by KurtBremser