Creating Macro Variables during PROC SQL Step Execution
INTO Clause and the NOPRINT Option Syntax
You
can create or update macro variables during the execution of a PROC
SQL step. Remember that the SELECT statement in a PROC SQL step retrieves
and displays data. The INTO clause in a SELECT statement enables you
to create or update macro variables.
When you create or update macro variables
during execution of a PROC SQL step, you might not want any output
to be displayed. The PRINT and NOPRINT options specify whether a SELECT
statement's results are displayed in output. PRINT is the default
setting.
|
Syntax, PROC SQL with
the NOPRINT option and the INTO clause:
PROC SQL NOPRINT;
SELECT column1<,column2,...>
INTO :macro-variable-1 ... |
Get SAS Certified Professional Prep Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
