PROC EXPORT to XLSX is creating a .bak file

[elwayfan446]

Hello, 

When I perform a proc export to xlsx it is creating a .bak file in the same directory.  Is there a way to prevent this?

proc export data=mydataset
dbms=xlsx
outfile="C:\Temp\myexcelfile.xlsx" replace;
sheet="myexcelsheet";
run;

[art297 · Accepted solution]

see: https://communities.sas.com/t5/Base-SAS-Programming/Clean-bak-files-from-PROC-EXPORT/td-p/316201

Art, CEO, AnalystFinder.com

[elwayfan446]

Thanks @art297.  I couldn't find anything here with my search of .bak.  Weird.  I guess I will try the fdelete function.  I thought there might be a parameter I was missing in the proc export function.

[art297]

I rely on Google for most searches. In this case I searched for: proc export sas bak file excel

Art, CEO, AnalystFinder.com

[elwayfan446]

same here.  I just missed that post somehow.  I appreciate the help.

[LaurieF]

I've thrown in a macro there to clean things up, free gratis and for nothing, which may help.