topic PROC EXPORT to XLSX is creating a .bak file in SAS Programming

PROC EXPORT to XLSX is creating a .bak file

elwayfan446 — Thu, 30 Mar 2017 13:52:16 GMT

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;

Re: PROC EXPORT to XLSX is creating a .bak file

art297 — Thu, 30 Mar 2017 14:13:02 GMT

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

Art, CEO, AnalystFinder.com

Re: PROC EXPORT to XLSX is creating a .bak file

elwayfan446 — Thu, 30 Mar 2017 14:19:58 GMT

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.

Re: PROC EXPORT to XLSX is creating a .bak file

art297 — Thu, 30 Mar 2017 14:24:03 GMT

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

Art, CEO, AnalystFinder.com

Re: PROC EXPORT to XLSX is creating a .bak file

elwayfan446 — Thu, 30 Mar 2017 14:28:39 GMT

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

Re: PROC EXPORT to XLSX is creating a .bak file

LaurieF — Tue, 30 May 2017 04:16:59 GMT

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