Exchanging Data between SAS and Microsoft Excel

Chapter 8: Creating Output Files with ODS for Use by Excel

8.1 Introduction

8.2 Purpose

8.3 An Introduction to SAS Tagset Templates That Create Files for Excel

8.3.1 How to Locate a Tagset Template

8.4 Difference Between an ODS Tagset and an ODS Destination

8.5 Syntax of the ODS CSV and CSVALL Output Processes

8.6 CSV and CSVALL Tagset Options

8.7 Overview of CSV and CSVALL Examples

8.8 CSV and CSVALL Examples to Write *.csv Files

Example 8.8.1 Simple CSV and CSVALL File Default Output Differences

Example 8.8.2 CSV and CSVALL Title and Footnote Output Differences

Example 8.8.3 Write Currency Values as Unformatted Numbers

Example 8.8.4 Change Delimiters When Outputting Data with CSV Tagset

Example 8.8.5 Save Leading Zeroes in Character Fields ...