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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.