Exchanging Data between SAS and Microsoft Excel

Chapter 5: SAS Enterprise Guide Methods and Examples

5.1 Introduction

5.2 Purpose

5.3 Typical Methods to Access Excel from SAS Enterprise Guide

5.4 Overview of the Examples

5.5 List of Examples

5.6 Examples

Example 5.1 Using the Export Method with Enterprise Guide

Example 5.2 Using the “Send To” Method

Example 5.3 Using the “Send To” Method to Output a Graph or Report

Example 5.4 Using the “Export” Method to Output a Graph or Report

Example 5.5 Using “Open” or “Import” Toolbar Options to Read Excel Workbooks

Example 5.6 Using the “Import Data” Toolbar Option to Read a Range of Cells

5.7 Conclusion

5.1 Introduction

This chapter is an introduction to moving data between SAS Enterprise Guide and Microsoft Excel. SAS Enterprise Guide has a lot of ...