Database Reference
In-Depth Information
Chapter 8: Creating Output Files with ODS for Use
by Excel
8.1 Introduction................................................................................................. 108
8.2 Purpose ....................................................................................................... 108
8.3 An Introduction to SAS Tagset Templates That Create Files for Excel ........ 109
8.3.1 How to Locate a Tagset Template ..........................................................................110
8.4 Difference Between an ODS Tagset and an ODS Destination ...................... 111
8.5 Syntax of the ODS CSV and CSVALL Output Processes ............................... 111
8.6 CSV and CSVALL Tagset Options................................................................. 111
8.7 Overview of CSV and CSVALL Examples ...................................................... 113
8.8 CSV and CSVALL Examples to Write *.csv Files........................................... 113
Example 8.8.1 Simple CSV and CSVALL File Default Output Differences ...................113
Example 8.8.2 CSV and CSVALL Title and Footnote Output Differences ....................115
Example 8.8.3 Write Currency Values as Unformatted Numbers .................................118
Example 8.8.4 Change Delimiters When Outputting Data with CSV Tagset................120
Example 8.8.5 Save Leading Zeroes in Character Fields Sent to Excel.......................123
8.9 Syntax of ODS MSOFFICE2K Output Processes to Write HTML Files........... 124
8.10 MSOFFICE2K Tagset Template Options .................................................... 125
8.11 Overview of MSOFFICE2K Examples ......................................................... 126
8.12 MSOFFICE2K Examples to Write HTML Files............................................. 126
Example 8.12.1 Generating an HTML Output File with No Options..............................126
Example 8.12.2 Generating an HTML File Using the Summary_Vars Option ..............127
8.13 Syntax of the ODS EXCELXP Tagset Template Output Processes ............. 128
8.14 ODS EXCELXP Tagset Options .................................................................. 130
8.15 Overview of EXCELXP Examples ............................................................... 132
8.16 EXCELXP Examples to Write XML Files..................................................... 133
Example 8.16.1 Generating an XML Output File with No Options ................................133
Example 8.16.2 Adjusting Column Width Using Tagset Template Options .................134
Example 8.16.3 Tagset Option to Hide Columns While Writing the File.......................135
Example 8.16.4 Apply an Excel “AUTOFILTER” to Selected Output Columns ............136
Example 8.16.5 Using Multiple Options to Produce a “Ready-to-Print”
Spreadsheet ........................................................................................................................137
Example 8.16.6 Creating a Table of Contents in an Excel Workbook ..........................138
Example 8.16.7 Methods of Naming Excel Worksheets.................................................140
Example 8.16.8 Splitting One Report onto Multiple Excel Worksheets .......................141
Example 8.16.9 Methods of Placing Labels in Excel Worksheet Names .....................142
Example 8.16.10 Use SHEET_INTERVAL= BYGROUP to Create Worksheets.............143
Example 8.16.11 Use SHEET_INTERVAL= PROC to Create Worksheets.....................144
Example 8.16.12 Build Separate Worksheets with Titles on Each Sheet.....................146
 
 
Search WWH ::




Custom Search