Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Several ODS destinations are commonly used for exporting output to Microsoft Excel. The most common destinations include Tagsets.ExcelXP, MSOffice2K, HTML/HTML3, and the CSV destination. All of these ODS destinations create output that can be read by Excel. However, none of these destinations generate native (binary) Excel files. The ExcelXP destination generates XML, the MSOffice2K (like the HTML/HTML3 destinations) generates HTML, and the CSV destination generates a comma-separated file. Because the output of all of these file formats is text, the file size can grow quickly depending on the amount of variables and observations in the data set.

Methods of reducing the file size include:

• Opening the file created with ODS and re-saving the file as a native Excel file.

• Creating a CSV file using the CSV destination.

• Programmatically modifying the output type of the file using DDE if on windows. Below is an example of programmatically saving the file to a native Excel file.
  ods tagsets.excelxp file="c:\temp\temp.xml"; proc print data=sashelp.class; run; ods tagsets.excelxp close; options noxwait noxsync; filename cmds dde 'excel|system'; data _null_; file cmds; X=SLEEP(10); put "[open(""C:\temp\temp.xml"")]"; put '[ERROR("FALSE")]'; put "[SAVE.AS(""C:\temp\temp.xls"",1)]"; X=SLEEP(2); put '[close("false")]'; run;

Operating System and Release Information