The SAS Output Delivery System and reporting techniques

ODS Excel Output

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 141
Accepted Solution

ODS Excel Output

Hello,

 

I have several SAS scripts that automate exporting data to an excel document via the ods excel file statement.  When I do this, the excel document opens automatically once completed.  Is there an option or a way to modify the statement so the excel document doesn't open automatically?

 

Thanks!


Accepted Solutions
Solution
‎02-08-2017 01:59 PM
Super User
Posts: 11,343

Re: ODS Excel Output

Posted in reply to elwayfan446

You environment may change the required approach.

One way in base SAS is to go to the Tool>Options>Preferences>Results menu choices and then unselect the "View results as they are generated" option. But that turns off automatic opening of anything untill the option is reset.

View solution in original post


All Replies
Solution
‎02-08-2017 01:59 PM
Super User
Posts: 11,343

Re: ODS Excel Output

Posted in reply to elwayfan446

You environment may change the required approach.

One way in base SAS is to go to the Tool>Options>Preferences>Results menu choices and then unselect the "View results as they are generated" option. But that turns off automatic opening of anything untill the option is reset.

Frequent Contributor
Posts: 141

Re: ODS Excel Output

Thanks @ballardw.  That did the trick.  I appreciate it.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 380 views
  • 1 like
  • 2 in conversation