SAS to Excel: ODS Tagsets to Hundred Files or Hundred Tabs

Abdus Shahid
Western Oregon University


Abstract

This paper will present methods of outputting dozens or hundreds of tables to an excel workbook as tabs or to hundreds excel files with the use of ODS Tagsets that comes with a table of contents. All the formatting for the tables are done with SAS codes, so that little or no manual formatting is needed once the final output is opened in excel. The method described is especially useful when a large number of tables are needed to be complied in one excel workbook. Some knowledge of Base SAS coding and XML output is required to fully utilize this process.