DATA Step, Macro, Functions and more

fdelete function

Reply
Frequent Contributor
Posts: 115

fdelete function

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

Contributor
Posts: 43

Re: fdelete function

Posted in reply to sunilreddy

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.

Super Contributor
Posts: 349

Re: fdelete function

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

Ask a Question
Discussion stats
  • 2 replies
  • 556 views
  • 0 likes
  • 3 in conversation