Creating Macro Variables during PROC SQL Step Execution
The INTO Clause and the NOPRINT Option
You
have seen how to create macro variables during DATA step execution.
You can also 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 | NOPPRINT option specifies whether a SELECT
statement's results are displayed in output. PRINT is the default
setting.
|
General form, PROC SQL with the NOPRINT option and the INTO clause: ... |
Get SAS Certification Prep Guide, 4th Edition 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.
