topic Moving Files on FTP Server in ODS and Base Reporting

Moving Files on FTP Server

deleted_user — Mon, 24 Jul 2006 06:21:24 GMT

I have this task in my project where i am asked to move "csv" files between directories on an FTP server using SAS. I know that "x-commands" will do it but i am not allowed to use these commands since they can harm the system !! therefore i am in need to know if there is another solution which will help me do so.

by the way , SAS is installed on Unix Server.
FTP server is on Novell OS.

Re: Moving Files on FTP Server

Cynthia_sas — Mon, 24 Jul 2006 23:09:18 GMT

Hi!
Using FTP or moving files on an FTP server is not related to ODS directly. You can try looking up the FTP access method for the FILENAME statement in the SAS documentation or contacting Tech Support for specific help on this task.
cynthia
(Some people DO use the FILENAME FTP access method to move ODS files, however, the use of this capability does not require ODS and is not limited to ODS.)

Re: Moving Files on FTP Server

deleted_user — Wed, 15 Aug 2007 20:02:36 GMT

%let Ftp_User=usercode;
%let Ftp_Pass=password;
%let Ftp_Host=999.999.999.999; /* Ip Address */

filename FtpFile
ftp "File.csv"
host="&Ftp_Host"
user="&Ftp_User"
pass="&Ftp_Pass";

data _null_;
length lineData $ 256;
set DataInputFile;
file FtpFile LRECL=256;

lineData = strip(Date) || "," || strip(MillCode) || "," || strip(Machine) || ",0," || strip(Product) || ",," ||
strip(actual) || ",MT," || strip(mtd);
put Linedata;
run;