O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exchanging Data From SAS to Excel

Book Description

Microsoft Excel remains the leading spreadsheet application on the market; nearly every SAS user will need to move their data and reports into Excel workbooks at some point during their career. Exchanging Data From SAS(R) to Excel: The ODS Excel Destination shows SAS users how to create Excel workbooks that are presentation ready, eliminating manual changes to the workbooks after creation. While the original book Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently touched upon many topics involved in moving data between SAS and Excel, this companion book delves into the options that are available with the ODS Excel destination. This book also has numerous examples that include syntax and graphical output. With this book, you can learn how to: Create native Excel files Insert graphs and images into Excel files Place multiple tables on multiple tabs within the file Customize spreadsheets with workbook-level options, print features, column features, row features, and cell-level features Exchanging Data from SAS® to Excel: The ODS Excel Destination will make sending your output and graphics to Excel a breeze, enhancing any presentation!

Table of Contents

  1. About This Book
  2. About The Author
  3. Chapter 1: Introduction
  4. Introduction
    1. What is the SAS ODS EXCEL Destination?
    2. Why I like Backward Compatibility
    3. Why the ODS Excel Destination Is an Output-Only Feature of SAS
    4. Layout of This Book
    5. General Chapter Layout
  5. Chapter 2: ODS Tagset versus Destination
  6. View of Microsoft Excel Changes from the Outside
  7. Data Sources Used as Examples
  8. The EXCELXP Tagset
  9. The ODS EXCEL Destination
  10. Features of the ODS EXCEL Destination
    1. Simple Syntax
    2. ID=
    3. Actions
    4. Optional Arguments (Options)
    5. Suboptions of the OPTIONS Statement
  11. General Chapter Descriptions
  12. Chapter 3: ODS Excel Destination Actions
  13. Introduction
  14. ODS Excel Destination Actions
  15. A Simple ODS Excel Example and the CLOSE Action
    1. A Simple ODS Excel Output Step
  16. Finding ODS Object Names Using the ODS TRACE Statement
    1. Using the ODS TRACE Statement to Show PROC UNIVARIATE Objects
  17. ODS EXCLUDE Statement
  18. ODS SELECT Statement
  19. ODS SHOW Statement
  20. Conclusion
  21. Chapter 4: Setting Excel Document Property Values
  22. Introduction
  23. Options to Modify the Excel Document Properties Sheet
  24. Default Excel Property Sheets
  25. Modify Excel Property Sheets with the ODS EXCEL Destination
  26. Excel Property Sheet Date/Time Fields without the SASDATE Option
  27. Excel Property Sheet Date/Time Fields with the SASDATE Option
  28. Conclusion
  29. Chapter 5: Options That Affect the Workbook
  30. Introduction
  31. ODS Excel Destination Actions
  32. The FILE= Option
  33. The ID= Option
  34. The BLANK_SHEET= Option
  35. The CONTENTS= Option
  36. The INDEX= Option
  37. The MSG_LEVEL= Option
  38. The TAB_COLOR= Option
  39. The ZOOM= Option
  40. Conclusion
  41. Chapter 6: Arguments that Affect Output Features
  42. Introduction
  43. Arguments That Affect Worksheet-Level Output Features
  44. Using the ODS Document Object Model (DOM) with the ODS EXCEL Statement
  45. The ODS ANCHOR= Option
  46. The BOX_SIZING= Option
  47. Using Cascading Style Sheets with the CSSSTYLE= Option
    1. Simple Color Changes Using a CSS File
    2. Sending Graphs to Excel and Modifying the Output Using a CSS File
    3. Adding a Background Image Using CSS
  48. The IMAGE_DPI= Option
  49. The STYLE= Option
  50. The ODS EXCEL STYLE= Option
    1. The ODS EXCEL STYLE= Overrides
  51. The TEXT= Option
  52. Conclusion
  53. Chapter 7: Options That Affect Worksheet Features
  54. Introduction
  55. ODS Excel Destination Suboptions
  56. The EMBEDDED_FOOTNOTES= Suboption
    1. Embedded Footnotes Turned Off
    2. Embedded Footnotes Turned On
    3. Embedded Footnotes=‘ON’ with Multiple Outputs on a Worksheet
  57. The EMBED_FOOTNOTES_ONCE= Suboption
    1. EMBED_FOOTNOTES_ONCE with Only One Output Table
    2. EMBED_FOOTNOTES_ONCE with More Than One Output Table
  58. The EMBEDDED_TITLES= Suboption
    1. EMBEDDED_TITLES=‘OFF’
    2. EMBEDDED_TITLES=‘ON’
  59. The EMBED_TITLES_ONCE= Suboption
    1. EMBED_TITLES_ONCE and Only One Output Worksheet
    2. EMBED_TITLES_ONCE with Multiple Outputs on a Worksheet
  60. The FITTOPAGE= Suboption
  61. The GRIDLINES= Suboption
  62. The PAGES_FITHEIGHT= Suboption
  63. The PAGES_FITWIDTH= Suboption
  64. The SHEET_INTERVAL= Suboption
    1. SHEET_INTERVAL=‘BYGROUP’ Example
    2. SHEET_INTERVAL=‘PAGE’ Example
    3. SHEET_INTERVAL=‘PROC’ Example
    4. SHEET_INTERVAL=‘NONE’ Example
    5. SHEET_INTERVAL=‘TABLE’ Example
  65. The SHEET_LABEL= Suboption
  66. The SHEET_NAME= Suboption
  67. The SUPPRESS_BYLINES= Suboption
  68. Conclusion
  69. Chapter 8: Options That Affect Print Features
  70. Introduction
  71. ODS Excel Destination Actions
  72. The BLACKANDWHITE= Option
  73. The CENTER_HORIZONTAL= Option
  74. The CENTER_VERTICAL= Option
  75. The DRAFTQUALITY= Option
  76. The ORIENTATION= Option
  77. The PAGE_ORDER_ACROSS= Option
  78. The PRINT_AREA= Option
  79. The PRINT_FOOTER= Option
  80. The PRINT_FOOTER_MARGIN= Option
  81. The PRINT_HEADER= Option
  82. The PRINT_HEADER_MARGIN= Option
  83. The ROWBREAKS_COUNT= Option
  84. The ROWBREAKS_INTERVAL= Option
  85. The ROWCOLHEADINGS= Option
  86. The SCALE= Option
    1. When Using Excel 2013, If You Enter:
  87. The TITLE_FOOTNOTE_NOBREAK= Option
  88. The TITLE_FOOTNOTE_WIDTH= Option
  89. Conclusion
  90. Chapter 9: Column, Row, and Cell Features
  91. Introduction
  92. ODS Excel Destination Column, Row, and Cell Options
  93. The ABSOLUTE_COLUMN_WIDTH= Suboption
  94. The AUTOFILTER= Suboption
  95. The COLUMN_REPEAT= Suboption
  96. The FROZEN_HEADERS= Suboption
  97. The HIDDEN_COLUMNS= Suboption
  98. The ABSOLUTE_ROW_HEIGHT= Suboption
  99. The FROZEN_ROWHEADERS= Suboption
  100. The HIDDEN_ROWS= Suboption
  101. The ROW_HEIGHTS= Suboption
  102. The ROW_REPEAT= Suboption
  103. The FORMULAS= Suboption
  104. The START_AT= Suboption
  105. Conclusion
  106. Index