O'Reilly logo

Learning SAS by Example by Ron Cody

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 26. Introducing the Structured Query Language

26.1

Introduction

536

26.2

Some Basics

536

26.3

Joining Two Tables (Merge)

539

26.4

Left, Right, and Full Joins

543

26.5

Concatenating Data Sets

546

26.6

Using Summary Functions

549

26.7

Demonstrating an ORDER Clause

551

26.8

An Example of Fuzzy Matching

551

26.9

Problems

553

Introduction

PROC SQL (structured query language—usually pronounced sequel) offers an alternative to the DATA step for querying and combining SAS data sets. There are some tasks that PROC SQL can perform much better and easier than the DATA step. Other tasks may be easier or more efficient using a DATA step. You may also be more familiar with SQL versus the DATA step or vice-versa. The best advice is to learn both and use the tool that works best ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required