There are many ways to read ODS output with Microsoft Excel, Word and PowerPoint.

Excel

• Excel from Tagsets.ExcelXP, MSOffice2K, HTML and CSV
  
  The bullets below contain syntax to get you started. For more in-depth information, see the PDF document Using ODS to Generate Excel Files and the updates in SAS 9.1 Microsoft Office Integration, as well as the SAS online documentation.
  
  
• Excel from HTML

  Beginning with SAS 9.1, you can use the TAGSETS.EXCELXP destination to generate XML output, which can be imported into a spreadsheet. This format allows you to generate multiple worksheets per workbook. This format does not currently support images, unike the MSOffice2K destination. When generating output from procedures, this is one of the best methods of keeping the table in the current format. Here is an example:

     ods Tagsets.ExcelxP body='temp.xml';
     proc print data=sashelp.class;
     run;
  
     proc print data=sashelp.class;
     run;
  
     ods Tagsets.ExcelxP close;
      

• Excel from HTML

  Excel can read HTML files which can be created from the ODS MSOffice2K destination beginning with SAS 9. When generating HTML in SAS 9 and later releases, the MSOFFICE2K destination is the preferable method of generating HTML which is read by Excel. Prior to SAS 9, the ODS HTML destination is the preferable method of generating HTML that can be read with Excel.

     ods MSOffice2K body='temp.xls';
     proc print data=sashelp.class;
     run;
  
     proc print data=sashelp.class;
     run;
  
     ods MSOffice2K close;
  

• Excel from CSV

  Excel can read files with comma-separated values (CSV). You can use the ODS CSV destination to generate CSV output from SAS procedures. To include the titles and footnotes, use the ODS CSVALL destination. Specifying ODS CSV destination yields the data without titles.

     ods csv file='temp.csv';
     proc print data=sashelp.class;
     run;
     ods csv close;
  

• You can use PROC EXPORT to export a SAS data set to a CSV file after the data set is created. Beginning with SAS Version 7.0, an output data set can be generated from any procedure.

     proc export data= work.test
                 outfile= "C:\temp.csv"
                 dbms=csv replace;
     run;
     

   ods rtf file='temp.rtf';
   proc print data=sashelp.class;
   run;
   ods rtf close;
     

   ods rtf file='temp.rtf';
   proc print data=sashelp.class;
   run;
   ods rtf close;