Date:         Tue, 20 Jul 2004 16:23:59 -0700
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: FTP Excel. Need help
Comments: To: David <oht3075@HOTMAIL.COM>

Hi David - I use recfm=f on the filename statements:

(tested)

filename ftpin 'test.xls' recfm=f ;
filename ftpout ftp '/test/test.xls'
         host='123.456.789' user='pchoate'
         pass="xxx"  recfm=f ;
filename ftpbkin 'test2.xls' recfm=f ;

data _null_;
    infile ftpin;
    file ftpout;
    input;
    put _infile_;
run;

data _null_;
    infile ftpout;
    file ftpbkin;
    input;
    put _infile_;
run;

hth

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David
Sent: Tuesday, July 20, 2004 12:01 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: FTP Excel. Need help

I need to ftp to an non-sas ftp server winin the SAS environment. I
use the follwoing Filename statement


 FILENAME f1 'c:\sas\test.xls'; run;

FILENAME webfile FTP '/finrep/ftp/ARTEST/test.xls'
  HOST='server.com' user='blarsen' pass='hello'
 recfm=S;
 run;

 data _null_;

  infile f1 ;
    ** How should I do the put statement (lengthwise since I am not
sure the length of the incoming excel file- binary) to input the file
and then output it using the FILE statement ?

Appreciated for any help.

Thanks

David