DATA Step, Macro, Functions and more

PROC EXPORT to XLSX is creating a .bak file

Accepted Solution Solved
Reply
Regular Contributor
Posts: 150
Accepted Solution

PROC EXPORT to XLSX is creating a .bak file

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;

Accepted Solutions
Solution
‎05-31-2017 09:55 AM
PROC Star
Posts: 7,657

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

Posted in reply to elwayfan446

All Replies
Solution
‎05-31-2017 09:55 AM
PROC Star
Posts: 7,657

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

Posted in reply to elwayfan446
Regular Contributor
Posts: 150

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

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.

PROC Star
Posts: 7,657

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

Posted in reply to elwayfan446

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


Art, CEO, AnalystFinder.com

Regular Contributor
Posts: 150

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

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

Super Contributor
Posts: 253

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

Posted in reply to elwayfan446

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 2138 views
  • 1 like
  • 3 in conversation