SQL

[SandyLing]

I want to know the difference with proc sql noprint  and proc sql print.Can you help me?

[manojinpec]

Noprint option will help preventing the output to be writtent to output window

[SandyLing]

But I use print still do not output

[manojinpec]

Please share screenshot

[RichardinOz]

The print option has no effect if you are creating a table.  PROC SQL will only print when you select but no table is created, eg

Proc SQL ;

     Select *

     from have ;

quit ;

We use Proc SQL Noprint when we want to create a macto variable but do not need print output ;

Proc SQL noprint ;

     Select value

          into :macvalue

     from have ;

quit ;

Richard in Oz