Exchanging Data between SAS and Microsoft Excel

Chapter 10: Using PROC SQL to Access Excel Files

10.1 Introduction

10.2 Purpose

10.3 Basic Syntax of the SQL Procedure

10.4 A Simple Explanation of SQL “PASS-THROUGH” Processing

10.5 Overview of the Examples

10.5.1 List of Examples

10.6 Examples

Example 10.1 LIBNAME Assignments to Access Excel Using PROC SQL

Example 10.2 Create an Excel File, Read It with SQL, and Then Compare the Files

Example 10.3 Use PROC SQL to Read a Subset of Records from an Excel Workbook

Example 10.4 Use PROC SQL Pass-Through Facilities to Process an Excel File

Example 10.5 Read a Pre-defined Range of Cells from an Excel Workbook

Example 10.6 Calculate a New Variable within the SQL Code and Sort the Output

Example 10.7 Examine the Contents and Structure of an Excel Workbook ...