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.
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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.