topic fdelete function in SAS Programming

fdelete function

sunilreddy — Fri, 20 Apr 2012 12:26:44 GMT

I am using below code to delet the file from below path, but its dleteing the file from the specified path and getting return code is 20029
data _null_;
rc1=filename("x","/opt/app/SAS/test/1.bin");
rc2=fdelete("x");
rc3=filename("x","");
put rc1= rc2= rc3=;
run;
output:
rc1=0 rc2=20029 rc3=0 ;

Using SAS 9.2. Can any one help me in this

Re: fdelete function

BobD — Fri, 20 Apr 2012 23:26:50 GMT

Well, either the file /opp/app/SAS/test/1.bin does not exist or the UNIX account from where you are running SAS does not have permission to delete the file.

The FILENAME function just defines a "fileref"; the file itself does not have to already exist.

Also, as an experiment, see if you can create a file and then delete it using the SYSTEM function to execute a plain old UNIX commands:

rc = system('touch /opt/app/SAS/test/foo'); /* Create an empty file */

put 'Created file foo' rc=;

rc = system('rm /opt/app/SAS/test/foo');

put 'Deleted file foo' rc=;

That might lead you to a solution.

Re: fdelete function

shivas — Mon, 23 Apr 2012 04:33:12 GMT

Hi Sunil,

Try this...it worked for me in window environment.

FILENAME test "F:\Test\tes.xlsx" ;

DATA _NULL_ ;

rc = FDELETE('test') ;

put rc=;

RUN ;

Thanks,

Shiva