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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.