DATA Step, Macro, Functions and more

how to rename excel filename

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

how to rename excel filename

I execute the script and export the excel file to my local folder. if i want to run the script again. i have to delete the excel and rerun since the excel filename already exist.IS there a way that i can execute without delete my excel file.


Accepted Solutions
Solution
‎03-26-2018 11:55 AM
PROC Star
Posts: 1,218

Re: how to rename excel filename

How do you export the Excel file? If you are using PROC EXPORT, remember to use the 

 

DBMS=EXCEL REPLACE;

Statement.

View solution in original post


All Replies
Solution
‎03-26-2018 11:55 AM
PROC Star
Posts: 1,218

Re: how to rename excel filename

How do you export the Excel file? If you are using PROC EXPORT, remember to use the 

 

DBMS=EXCEL REPLACE;

Statement.

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation