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 10. Subsetting and Combining SAS Data Sets

10.1

Introduction

162

10.2

Subsetting a SAS Data Set

162

10.3

Creating More Than One Subset Data Set in One DATA Step

163

10.4

Adding Observations to a SAS Data Set

164

10.5

Interleaving Data Sets

167

10.6

Combining Detail and Summary Data

168

10.7

Merging Two Data Sets

170

10.8

Omitting the BY Statement in a Merge

172

10.9

Controlling Observations in a Merged Data Set

173

10.10

More Uses for IN= Variables

175

10.11

When Does a DATA Step End?

176

10.12

Merging Two Data Sets with Different BY Variable Names

177

10.13

Merging Two Data Sets with Different BY Variable Data Types

179

10.14

One-to-One, One-to-Many, and Many-to-Many Merges

181

10.15

Updating a Master File from a Transaction File

183

10.16

Problems

185

Introduction

This chapter describes ...

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