topic Re: SQL in SAS Procedures

SQL

SandyLing — Tue, 20 Nov 2012 06:18:08 GMT

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

manojinpec — Tue, 20 Nov 2012 06:27:31 GMT

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

SandyLing — Tue, 20 Nov 2012 07:14:26 GMT

But I use print still do not output

manojinpec — Tue, 20 Nov 2012 08:43:38 GMT

Please share screenshot

RichardinOz — Tue, 20 Nov 2012 12:02:05 GMT

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