Help using Base SAS procedures

PROC EXPORT, backup .xlk

Reply
New Contributor
Posts: 4

PROC EXPORT, backup .xlk


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.

Contributor
Posts: 72

Re: PROC EXPORT, backup .xlk

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"

Ask a Question
Discussion stats
  • 1 reply
  • 792 views
  • 0 likes
  • 2 in conversation