Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

To dynamically transfer output by FTP from a SAS job, specify the FILENAME statement with the FTP access method. This creates the output file on the target host. In the HOST= argument, specify the IP address or the string that your site uses to connect to the host. Below is an example that creates the file x.html in my home directory on my UNIX server. For full documentation, see the FILENAME statement in the OnlineDoc.

   filename temp ftp '~my-user-id/x.html'
            user='my-user-id' host='node.company.com'
            pass='xxxx'
            recfm=s
            prompt debug;

   ods html body=temp;

   proc print data=sasuser.class;
   run;

   ods html close;

The above method only works with a single body file. If you have multiple files to FTP, such as multiple body files, or the supporting files such as the table of contents and the frame file, you can use the below approach on the PC to create a ZIP file. Otherwise, you need multiple FILENAME statements with the FTP access method to FTP each file.

The below example pipes all of the files generated with ODS to a ZIP file. It is then the ZIP file that is FTP'd. If you have SAS Integration Technologies, then you can create a package to send. For more information, see the example "Publishing with the FTP Access Method" in SAS Integration Technologies Developer’s Guide.

   options noxwait noxsync;
   ods listing close ;

   ODS HTML PATH='c:\test'(URL=NONE)
       body='body.html'
       contents='contents.html'
       frame='frame.html' newfile=proc;

   /* sample Data */
   proc print data=sashelp.class;
      title "first title";
   run;

   proc print data=sashelp.houses;
      title2 'second title';
   run;
   ODS HTML CLOSE;

   /* Use the Pipe command to pipe all of the body files generated and */
   /* all of the supporting files.                                     */

   filename zipit pipe 'c:\winzip\wzzip.exe  c:\test.zip c:\body*.html
            c:\contents.html c:\frame.html';

   data _null_;
      file zipit;
      put 'The will zip the files';
   run;
   filename zipit clear;

   /* FTP the zipped file created */
   filename moveit ftp '~my-user-id/test.zip'
            host='node.company.com' prompt debug
            user='my-user-id'
            pass='abc123' recfm=f;
   data _null_;
      file moveit;
      put;
   run;
   ods listing;

Operating System and Release Information