fdelete function

[sunilreddy]

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

[BobD]

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.

[shivas]

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