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
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.