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.
Filename sftp requires that passwordless authentication (public/private key) has been established; therefore it does not have a password option.
May be the following link will be of help: http://support.sas.com/kb/56/154.html
Link edited by @Kurt_Bremser
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.