SAS 9.4 Macro Language, 2nd Edition

Chapter 18

SQL Clauses for Macros

SQL Clauses for Macros

Dictionary

INTO Clause

SQL Clauses for Macros

Structured Query Language (SQL) is a standardized, widely used language for retrieving and updating data in databases and relational tables.

Dictionary

INTO Clause

Assigns values produced by PROC SQL to macro variables.

Type:

SELECT statement, PROC SQL

Syntax

INTO : macro-variable-specification-1 <, : macro-variable-specification-2 …>

Required Argument

macro-variable-specification

names one or more macro variables to create or update. Precede each macro variable name with a colon (:). The macro variable specification can be in any one or more of the following forms:

: macro-variable

specify one or more macro variables. Leading and trailing ...