• support.sas.com
• KNOWLEDGE BASE
• SUPPORT
• LEARNING CENTER
• COMMUNITY

ODS and Microsoft Excel

Base SAS

Sample Gallery of Programs for ODS and Excel

This page is linked from the PDF document Using ODS to Generate Excel Files.

1. Page Setup
   1. window options
   2. print setup options
   3. print titles
   4. print area
   5. Header and footers
   6. Landscape output
   7. Legal output
2. Cell Formatting
   1. preserve leading 0 with CSV
   2. preserve leading 0 with HTML
   3. conditional formatting
3. TITLES
   1. Merging titles
   2. Removing space between Titles
   3. Modify title size and alignment
   4. Adding date to the title
   5. Modifying individual titles
4. General
   1. Sorting
   2. protect worksheets
   3. protect workbooks
   4. Window size
   5. number of copies
   6. Create backup
   7. Split screen
   8. gridlines
   9. page breaks
   10. Zoom
   11. Macro executed on open
   12. Data validation
   13. freeze headers
   14. conditional formatting
   15. Hide Worksheet
   16. Setting Width
5. Multiple Worksheets per workbook
   1. multiple Worksheets per workbook
   2. multiple worksheets per by-group
   3. multiple worksheets without the warning
   4. multiple worksheets for each member in library
   5. multiple worksheets for each HTML file in a directory
   6. multiple worksheets for Excel 2002 dynamically