HI,
I have a data step that exports to excel . I need to delet /remove the original file. How do I go about deleting the file before the export process starts
I currently have this script for deleting it's not working
filename myfile "c:\daily\GT.xlsx";
rc=fdelete(myfile);
run;
filename myfileclear;
Try This:
filename myfile "c:\daily\GT.xlsx";
data _null_;
rc=fdelete("myfile");
run;
filename myfileclear;
You must have permission to delete the file.
CTorres
If you are using proc export then add the REPLACE option to overwrite the existing file. No need for a separate step to delete.
proc export data=yourdate outfile="your file name" dbms=excelcs (or which ever you are using) REPLACE; run;
HI,
Ive tried that option an it doesn't replace the original file it happen when I convert to xlsx format.
so deleteing it is best option since it runs every three hours..
i Have this code that deletes what I need but the cmd prompt window stays open any ideas how to close it?
%let fname =GT.xlsx;
%let dir=H:\Test\;
x del "&edit.\&fname.";
options noxwait; before the X command.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.