Sharpening Your Advanced SAS Skills

Chapter 1

Accessing Data Using SQL

Chapter Overview

1.1 Introduction

1.2 Table Access and Retrieval

1.3 Creating Macro Variables

1.4 Table Structure Operations

1.5 Table Content Operations

1.6 Connecting to Relational Databases

1.1 Introduction

This chapter is organized to facilitate easy searching of key points by summarizing and differentiating the syntax between similar SAS statements and options. The basic syntax for PROC SQL will be explained and illustrated with simple task-oriented examples. Questions will be included at the end of each section to reinforce the user’s knowledge of the topic.

At the beginning of the chapter, a chapter overview ...