topic Re: how to delete excel file when exporting in SAS Procedures

how to delete excel file when exporting

BETO — Wed, 14 Jan 2015 19:22:59 GMT

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;

Re: how to delete excel file when exporting

CTorres — Wed, 14 Jan 2015 20:13:48 GMT

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

Re: how to delete excel file when exporting

ballardw — Wed, 14 Jan 2015 20:21:57 GMT

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;

Re: how to delete excel file when exporting

BETO — Wed, 14 Jan 2015 22:20:48 GMT

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.";

Re: how to delete excel file when exporting

Haikuo — Wed, 14 Jan 2015 22:35:02 GMT

for your question: options noxwait;

Personally I prefer 's solution, as it is more OS independent.

Re: how to delete excel file when exporting

ballardw — Wed, 14 Jan 2015 22:36:22 GMT

options noxwait; before the X command.