Groups | Search | Server Info | Login | Register

Groups > comp.soft-sys.sas > #958

upload excel files to ftp site using SAS

Show all headers | View raw

I have some problem when I try to upload excel files to ftp using SAS,
The following code works well if I upload a SAS file,I could download
and open it again.  but if I  change to test.xls, the file on the ftp
site is not correct, it gives me unrecognized characters, and only a
few letters.

filename newfile ftp "alg.sas" cd = 'folder' user = 'username'
pass = 'pw' host = 'ftp.mysite.com';
data _null_;
infile "E:\locafolder\alg.sas";
file newfile;
input;
put _infile_;
run;

The log file shows the difference is: for SAS file, NOTE: 158 records
were read from the infile ".
but for excel fiels, the log shows: NOTE: 1 record was read from the
infile.

Could you help on how SAS work on Excel when using FTP, how to fixed.
Most of likely we need upload several excel file every week, I would
like to automate.

Thanks

Back to comp.soft-sys.sas | Previous | Next — Next in thread | Find similar

Thread

upload excel files to ftp site using SAS tengteng <mrxtengteng@gmail.com> - 2011-06-17 11:27 -0700
  Re: upload excel files to ftp site using SAS "data _null_;" <iebupdte@gmail.com> - 2011-06-17 14:15 -0700

csiph-web