Help using Base SAS procedures

Deleting external file in FTP...

Reply
Contributor
Posts: 21

Deleting external file in FTP...

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.

Frequent Contributor
Posts: 75

Re: Deleting external file in FTP...

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

Grand Advisor
Posts: 9,452

Deleting external file in FTP...

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

Contributor
Posts: 21

Re: Deleting external file in FTP...

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

Ask a Question
Discussion stats
  • 3 replies
  • 802 views
  • 6 likes
  • 3 in conversation