| Date: | Tue, 20 Jul 2004 16:02:12 -0500 |
| Reply-To: | Gary Ross <gary_ross@MGIC.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Gary Ross <gary_ross@MGIC.COM> |
| Organization: | http://extra.newsguy.com |
| Subject: | Re: FTP Excel. Need help |
| Content-Type: | text/plain; charset=us-ascii |
David wrote:
>
> 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
You are close. Try (UNTEST) adding:
infile f1;
input:
file webfile;
put _infile_ ;
run;
|