topic Re: ODS How to stop "Open, Save, Cancel" Dialog in ODS and Base Reporting

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

deleted_user — Fri, 19 Oct 2007 11:14:33 GMT

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?

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

Cynthia_sas — Fri, 19 Oct 2007 14:03:35 GMT

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

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

Olivier — Mon, 22 Oct 2007 08:41:51 GMT

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