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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.