SAS Certified Specialist Prep Guide

Creating EXCEL Output with ODS

The ODS EXCEL Statement

To open, manage, or close the Excel destinations that produce Excel spreadsheet files that are compatible with Microsoft 2010 and later versions, use the ODS EXCEL statement:

Syntax, ODS EXCEL statement: ODS EXCEL <(<ID=>identifier)> <action>; ODS EXCEL <(<ID=>identifier)> <option(s)>; (<ID=>identifier) enables you to open multiple instances of the same destination at the same time. Each instance can have different options. identifier can be numeric or can be a series of characters that begin with a letter or an underscore. Subsequent characters can include letters, underscores, and numerals. action can be one of the following: CLOSE action closes the destination ...