Help using Base SAS procedures

SQL

Reply
New Contributor
Posts: 2

SQL

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

Frequent Contributor
Posts: 138

Re: SQL

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

New Contributor
Posts: 2

Re: SQL

But I use print still do not output

Frequent Contributor
Posts: 138

Re: SQL

Please share screenshot

Super Contributor
Posts: 644

Re: SQL

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

Ask a Question
Discussion stats
  • 4 replies
  • 217 views
  • 0 likes
  • 3 in conversation