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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.