SAS Institute. The Power to Know

FOCUS AREAS
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