topic Re: Deleting external file in FTP... in SAS Procedures

Deleting external file in FTP...

Liangck — Tue, 27 Sep 2011 03:12:04 GMT

Hi all,

Suppose i have a senario that read external file from ftp and after reading it, i wish to made a deletion on that particular external file.

i tried FDELETE but seem it cant do so.

my colleage tell that fdelete function are only access to a local directory but not remote directory.

is there any other method to do so?

Seeking for help, thanks you. Apperciate its alot.

Regards

LiangCk.

Re: Deleting external file in FTP...

dhana — Tue, 27 Sep 2011 06:07:17 GMT

You can specify the delete command on the RCMD parameter of the filename statement.

FILENAME FILEREF FTP "ABC.DAT" HOST="TESTHOST" USER="USERNAME" PASS="PASSWORD" RCMD="DELE ABC.DAT";

otherwise you can try this also

QUOTE RCMD DLTF FILE(mylib/myfile)

mylib is the name of the library from which the file is to be deleted. myfile is the name of the file to be deleted.

Hope this helps...!

Thanks

Dhanasekaran R

Deleting external file in FTP...

Ksharp — Tue, 27 Sep 2011 06:13:50 GMT

Firstly , make sure you have right to deleting files at ftp .

And also you can use OS command to delete it.

Start-> Run-> cmd-> ftp 10.1.2.2 -> del ....

Maybe it should be worked.

Ksharp

Re: Deleting external file in FTP...

Liangck — Thu, 29 Sep 2011 04:05:17 GMT

Hi DHNA and Ksharp

thanks for your advice, i done it with fdelete alreadly..

the code like this

filename fileDel ftp "&&SAS_Import&&Note&I&&Data_Upload&&Docm&J"
     host=&ftpHost  
     user=&ftpUser pass=&ftpPass
     prompt;
%let rc = %sysfunc(fdelete(fileDel));

Thanks anyway.Apperciate your help.

Regards:

Liangck