BookmarkSubscribeRSS Feed
Chalin
Calcite | Level 5


Is there a way to use proc export to create an excel file without saving a backup .xlk file?  I have gone into excel tools and unchecked the box that says 'always create backup' and it always seems to be rechecked when I use the export procedure.

1 REPLY 1
robby_beum
Quartz | Level 8

hmmm, this issue seems to be an excel problem, not a SAS problem. It also sounds like you're doing it correctly in Excel to turn off the 'always create backup'. Is it an option to reinstall Excel?

From stackoverflow.com:

What you need to do is open any excel file and choose the "save as" option. When you are in the save as window, below the "File name" and "Save As Type" options, there is an option that reads "Tools" with a small drop down arrow next to it. Click on this drop down arrow and then from the dropdown list, choose "General Options". In the window that pops up next, check the box that reads " Always create Backup"

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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