Samples & SAS Notes > SAS Reference
>
ODS (Output Delivery System)
| Date | Title | Type | ||
|---|---|---|---|---|
| 7/11/05 |
23664 - How can I send ODS output to Excel, Word, PowerPoint, and Oracle? There are many ways to read ODS output with Excel, Word, PowerPoint, SPSS, Oracle, and Access. Excel Excel from HTML and CSV The bullets below contain syntax to get you started. For more in-depth information, see ... http://support.sas.com/kb/23/664.html, 21KB |
Usage Note | ||
| 10/22/07 |
24823 - Get Clean PROC Output into Excel Using ODS This sample shows how to get SAS output into EXCEL (without using the ODS EXCEL option). http://support.sas.com/kb/24/823.html, 22KB |
Sample | ||
| 10/5/09 |
37040 - ODS creates output files for Excel that are very large Some files generated by ODS for use with Excel are very large. This note contains information and sample code to reduce the file size. http://support.sas.com/kb/37/040.html, 20KB |
Usage Note | ||
| 7/23/08 |
32739 - Garbage characters might display when exporting a dataset to Excel The following SAS® code might cause garbage characters to display in the title in Microsoft Excel. %let _ODSDEST = tagsets.MSOffice2K; %STPBEGIN; title "В Г Д Ж З И Й ... http://support.sas.com/kb/32/739.html, 22KB |
Usage Note | ||
| 6/11/08 |
32414 - How can I prevent loss of leading zeroes when generating Microsoft Excel output with ODS Excel ods http://support.sas.com/kb/32/414.html, 20KB |
Usage Note | ||
| 3/12/04 |
11959 - Graphs in Excel files generated from ODS may overlap It is possible to create files that are automatically opened by Microsoft Excel from the ODS HTML destination by including the .XLS extension on the file name, such as: ODS HTML FILE='FILE.XLS'; If graphs are ... http://support.sas.com/kb/11/959.html, 21KB |
Problem Note | ||
| 2/16/09 |
31956 - Using the MSOffice2k ODS destination with Microsoft Excel 2007 generates a dialog box When you use the ExcelXP and MSOffice2K ODS destinations to generate output that will be opened in Microsoft Excel 2007, a new dialog box is generated if you use the .xls extension. The dialog box is generated ... http://support.sas.com/kb/31/956.html, 20KB |
Usage Note | ||
| 8/28/07 |
23689 - How can I download an Excel file from an ODS HTML Web page? You can place a download button on the HTML page that enables the reader to save the page as an Excel file. Use the Input tag along with the document.execCommand JavaScript command in the PREHTML= attribute of PROC ... http://support.sas.com/kb/23/689.html, 17KB |
Usage Note | ||
| 10/17/08 |
33564 - Creating multiple worksheets per Microsoft Excel workbook using ODS Using the Excelxp destination to generate multiple worksheets per workbook http://support.sas.com/kb/33/564.html, 19KB |
Usage Note | ||
| 10/3/07 |
23650 - How can I generate RTF, XML, PDF, and Excel files with ODS and SAS/IntrNet? You can use the APPSRV_HEADER function to override the default mime header that ODS generates. The below examples use the function to change the content-type in order to render the desired kind of output. The ... http://support.sas.com/kb/23/650.html, 18KB |
Usage Note | ||
