The SAS Output Delivery System and reporting techniques

ODS How to stop "Open, Save, Cancel" Dialog

Reply
N/A
Posts: 0

ODS How to stop "Open, Save, Cancel" Dialog

I am creating an HTML document with an XLS extension. When the ods statement finishes, I get a dialog asking if I want to Open or Save the resulting document. How can I disable the dialog?
SAS Super FREQ
Posts: 8,740

Re: ODS How to stop "Open, Save, Cancel" Dialog

Hi:
I believe this happens if you don't have a local copy of Office or if your Windows registry does not associate Excel with the file extension XLS. This will also happen if you don't have a local copy of Word (to open RTF). The fix is to change the file extension association -- as described here for RTF:
http://support.sas.com/faq/040/FAQ04022.html
http://support.sas.com/techsup/unotes/SN/009/009627.html
http://support.sas.com/techsup/unotes/SN/013/013128.html

cynthia
Super Contributor
Posts: 260

Re: ODS How to stop "Open, Save, Cancel" Dialog

It also happens when SAS wants to display the results automatically. You should take a look at the TOOLS > OPTIONS > PREFERENCES menu, then the RESULTS tab, and uncheck the VIEW RESULTS AS THEY ARE GENERATED check box.
It may prevent the dialog box from openning.

Regards,
Olivier
Ask a Question
Discussion stats
  • 2 replies
  • 441 views
  • 0 likes
  • 3 in conversation