noprint option in proc sql

[Ronein]

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;

[gamotte]

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.;

[PeterClemmensen]

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#a00...

[Onizuka]

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.

[AMSAS · Accepted solution]

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