Exchanging Data between SAS and Microsoft Excel

Chapter 7: SAS Add-In for Microsoft Office (Excel)

7.1 Introduction

7.2 Purpose

7.3 Methods of Sharing Data Using SAS Add-In for Microsoft Office

7.4 List of Examples

7.5 Examples

Example 7.1 Open a SAS Dataset Using SAS Add-In for Microsoft Office

Example 7.2 Open a SAS Report Dataset (*.srx) Using SAS Add-In for Microsoft Office

7.6 Conclusion

7.1 Introduction

The software architecture of the Microsoft products incorporate something called a Component Object Model (COM) software package. The SAS Add-In for Microsoft Office is a COM package. Once installed into Microsoft Excel and other Microsoft products, the SAS Add-In for Microsoft Office gives you access to SAS features directly from Excel. The SAS Add-In for Microsoft Office is part of ...