The DS2 Procedure: SAS Programming Methods at Work

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 ...