topic Re: Transfer a zip file from other server to sas sftp server in SAS Procedures

Transfer a zip file from other server to sas sftp server

vimal — Wed, 15 Jun 2011 05:32:09 GMT

Dear ,

I am using this code to transfer a zip file from other server to sas sftp server.
But I am getting a corrupted file.
Please help me.

data _null_ ;
X 'umask 0000';
run;

x '@echo off';
x 'cd ';
x 'echo open > b.ftp';
x 'echo user user pwd >> b.ftp' ;

x "echo cd b.ftp";
x 'echo asc >> b.ftp';
x "echo get 6546_file.zip >> b.ftp";

x 'echo bye >> b.ftp ';
x 'ftp -ni <<destination_location>b.ftp > b.ftplog';

x 'echo bye';

Re: Transfer a zip file from other server to sas sftp server

DF — Wed, 15 Jun 2011 08:04:55 GMT

You might try specifying binary transfer mode before moving any of the files? Just send the command "bin" in the same way you have done so for the others.

Re: Transfer a zip file from other server to sas sftp server

vimal — Thu, 16 Jun 2011 09:22:09 GMT

Dear DF,

Can you please alloborate some more as I am a new to programming.

Re: Transfer a zip file from other server to sas sftp server

DF — Thu, 16 Jun 2011 15:22:50 GMT

Sure - sorry if I was a bit too vague!

You have a line in your code that reads:

x 'echo asc >> b.ftp';

The "asc" tells FTP to transfer the file in ASCII mode. This works for text files like CSV or .tab, etc. and will automatically translate between Windows and UNIX text formats (for example).

However a ZIP file is not a text file, so this reformatting will corrupt the file. Try changing it instead to be:

x 'echo bin >> b.ftp';

That should tell it to copy in binary mode, and should hopefully stop your file corruption.

This article has some good notes on the subject: http://www.remote-control.net/articles/2006/ftp_notes/

Hope that helps!