Have you tried the filename statement with ftp access method? Here's doc, SAS(R) 9.3 Statements: Reference and example. This example reads the file ftpmem1 from a directory on a UNIX host, and writes the file ftpout1 to a different directory on another UNIX host. filename indir ftp '/usr/proj2/dir1' DIR host="host1.mycompany.com" user="xxxx" prompt; filename outdir ftp '/usr/proj2/dir2' DIR FILEEXT host="host2.mycompany.com" user="xxxx" prompt; data _null_; infile indir(ftpmem1) truncover; input; file outdir(ftpout1); put _infile_; run; The file ftpout1 is written to /usr/proj2/dir2/ftpout1.DATA . Note that a member type of DATA is appended to the ftpout1 file because the FILEEXT option was specified in the output file's FILENAME statement. Note: The DIR option is not needed for some ODS destinations. The following example writes an output file and transfers it to an ODS-specified destination. The DIR option is not needed. filename output ftp "~user/ftpdir/" host="host.fyi.company.com" user="userid" pass="userpass" recfm=s debug; ods html body='body.html' path=output; proc print data=sashelp.class;run; To export multiple graph files to a remote directory location, the DIR option must be specified in the FILENAME statement. Accordingly, when creating external graph files with the ODS HTML destination, two FILENAME statements are needed: one for the HTML files, and one for the graph files. The following example illustrates the need for two FILENAME statements. filename output1 ftp "~user/dir" fileext host="host.unx.company.com" user="userid" pass="userpass" recfm=s debug; filename output2 ftp "~user/dir" dir fileext host="host.unx.company.com" user="userid" pass="userpass" recfm=s debug; ods html body='body.html' path=output1 gpath=output2 frame='frames.html' contents='contents.html'; proc gtestit; run; quit; ;
... View more