Exchanging Data between SAS and Microsoft Excel

Chapter 2: Use PROC EXPORT to Write SAS Data to External Files and Excel Workbooks

2.1 Introduction

2.2 Purpose

2.3 Syntax of the SAS EXPORT Procedure

2.4 Data Access Methods for Excel Files Supported by PROC EXPORT

2.5 Overview of the Examples

2.6 List of Examples

Example 2.1 SAS Code to Export Data to an Excel 4 or Excel 5 Format File

Example 2.2 PROC EXPORT Using the DBMS=DLM Option

Example 2.3 PROC EXPORT Using the DBMS=EXCEL Option

Example 2.4 PROC EXPORT Using the DBMS=EXCELCS Option

Example 2.5 SAS Code to Export Data to an Excel File with No Column Headers

Example 2.6 SAS Code to Export Data to a Network Windows Computer

2.7 Conclusion

2.1 Introduction

This chapter will explain the syntax, usage, and the results that can be generated ...