DATA Step, Macro, Functions and more

PROC EXPORT to XLSX is creating a .bak file

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 140
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,362

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


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

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

Frequent Contributor
Posts: 140

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,362

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

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


Art, CEO, AnalystFinder.com

Frequent Contributor
Posts: 140

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: 251

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

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
  • 870 views
  • 1 like
  • 3 in conversation