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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.