O'Reilly logo

The DS2 Procedure: SAS Programming Methods at Work by Peter Eberhardt

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 8: Data Sources

Overview

Sample Tables

SET

SET Data Set Options

SET with No BY Statement

SET with BY Statement

SET with FedSQL as a Data Source

Merge

Merge with FedSQL as a Data Source

Threads

Thread Methods

Thread Parameters

SQLSTMT Package

SQLSTMT Binding

SQLSTMT – Returning the Rows

Overview

In the DATA step, you have three fundamental data sources:

1.   The SET statement reads existing tables.

2.   The MERGE statement reads and matches or merges existing tables.

3.   The INPUT statement reads raw text files.

Both SET and MERGE operate on tables or views. The tables and views can come from a variety of sources, but they are always tables or views that have already been defined. With data set options, you can control which columns should ...

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