topic noprint option in proc sql in SAS Programming

noprint option in proc sql

Ronein — Tue, 16 Apr 2019 08:30:52 GMT

Hello

When do we add noprint option to proc sql?

What is the difference between proc sql without noprint option and proc sql with noprint option

For example:

proc sql noprint;
create table bbb as
select * 
from sashelp.cars
where origin='Asia'
;
quit;


proc sql ;
create table ccc as
select * 
from sashelp.cars
where origin='Asia'
;
quit;

Re: noprint option in proc sql

gamotte — Tue, 16 Apr 2019 08:45:19 GMT

Hello,

Try with this query instead to see the difference :

proc sql ;
select distinct make 
into :make_lst separated by ','
from sashelp.cars
where origin='Asia'
;
quit;

%put &make_lst.;

Re: noprint option in proc sql

PeterClemmensen — Tue, 16 Apr 2019 09:12:57 GMT

The NOPRINT Option also affects the automatic macro variable SQLOBS. See the code below

proc sql noprint;
   select * from sashelp.class;
quit;

%put &SQLOBS.;

proc sql;
   select * from sashelp.class;
quit;

%put &SQLOBS.;

And read more here

http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001360983.htm#a001404680

Re: noprint option in proc sql

Onizuka — Tue, 16 Apr 2019 09:48:53 GMT

When you use the "noprint" option, it simply means that you are not going to have a display output on your screen. It can be used when you are creating macro-variables. For example :

Proc sql /* noprint */ ;
select name into: list /* this create a macro variable "list" which contain all valus of var name */
from example;
quit ;

So when you do this, you may don't want to see the output so you put the option noprint.

Re: noprint option in proc sql

AMSAS — Thu, 30 Jun 2022 11:07:14 GMT

Editors note:
Both responses from @PeterClemmensen and @Onizuka are correct
For full details see PRINT | NOPRINT Documentation and Using the PROC SQL Automatic Macro Variables