Exchanging Data between SAS and Microsoft Excel

Chapter 1: Easy Data Movement between SAS and Microsoft Excel

1.1 Introduction

1.2 Examination of Excel Files

1.2.1 Purpose

1.2.2 Excel Data Types

1.2.3 General Excel Workbook Limitations

1.2.4 Excel Workbook Formatting Groups

1.2.5 Excel Data Ranges

1.3 Examples of Copy-and-Paste Techniques

1.3.1 Highlight, “Cut” or “Copy,” and Then “Paste”

1.3.2 Convert Text Data to Excel Column Data Fields

1.3.3 Copy Data to the SAS Enhanced Editor Window for Use in a SAS Program

1.3.4 Save Multiple Lines of Text in a Single Excel Cell

1.3.5 Converting Excel Tables to Text

1.4 Accessing Excel Data from the SAS Explorer Window and Toolbar

1.4.1 SAS Explorer Window and Toolbar Processing Method Descriptions

1.4.2 Picking the Export Wizard from the SAS Explorer ...