SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

else do;

submit sql immediate;

create view &viewname as &viewdef;

end submit;

end;

The following example retrieves the data from the Countries table, but does not display

the table because the NOPRINT option is specified in the PROC SQL statement. The

%PUT macro language statement displays the three automatic macro variable values in

the SAS log. For more information about the %PUT statement and the SAS macro

facility, see SAS Macro Language: Reference.

libname sql 'SAS-library';

proc sql noprint;

select * from sql.countries;

%put SQLOBS=*&sqlobs* SQLOOPS=*&sqloops* SQLRC=*&sqlrc*;

Log 5.10 Using the PROC SQL Automatic Macro Variables

SQLOBS=*1* SQLOOPS=*11* ...