Exchanging Data between SAS and Microsoft Excel

Chapter 4: Using the SAS LIBNAME to Process Excel Files

4.1 Introduction

4.2 Purpose

4.3 Excel-Specific Features of the SAS LIBNAME Statement

4.4 Syntax of the SAS LIBNAME Statement

4.5 LIBNAME Statement ENGINE CONNECTION OPTION Descriptions

4.5.1 HEADER Option to Read Variable Names

4.5.2 MIXED Option to Select Data Types

4.5.3 PATH Option to Define Physical File Locations

4.5.4 VERSION Option to Identify Excel File Version

4.5.5 PROMPT Option to Interactively Assign a Libref

4.5.6 Other Common SAS PC File LIBNAME Options

4.6 Excel-Specific Dataset Options

4.7 UNIX, LINUX, and 64-Bit Windows Connection Options

4.8 Overview of the Examples

4.8 List of Examples

4.9 Examples

Example 4.1 Using the Engine Connection HEADER Option

Example 4.2 Using ...