Hello,
I am creating two XLS report using proc report and ods excelxp.tagset (I am using SAS 9.3 on Windows). The code run without any errors and the report is created but after the file is created a SAS window is displayed asking if I want to open the XLS file in SAS. I have managed to disable this message window only by manually changing the options in Tools-->Options-->Preferences-->Results. The problem is that even if I change the display options in one session, SAS will still revert to the default settings when a new session is started.
I have tried to use ods _all_ close, ods html close but no results. I think that the default options can be changed in the ODS SAS registry but I don't want to so far.
Would anybody know what should I do to stop displaying that message window?
Thank you,
Madalin
If you don't want files created by SAS to automatically open after creation, put in - either to your startup files, or you program:
ods noresults;
That will turn the feature off. It can go in your programs, or in autoexec.sas.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: