BookmarkSubscribeRSS Feed
GabrielGajardo
Fluorite | Level 6

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.

2 REPLIES 2
Patrick
Opal | Level 21

@GabrielGajardo

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

 

Link edited by @Kurt_Bremser

 

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2761 views
  • 2 likes
  • 3 in conversation