BookmarkSubscribeRSS Feed
dineshhnk
Calcite | Level 5

Hi,

 

I'm a newbie to SAS and getting hands on with procsql

 

how do i get output displayed in output window ?

 

 

PROC SQL;
SELECT count(*)  FROM Work.Gender;
QUIT;

 

 

Log is displaying below warning message 

 

13562 PROC SQL;
13563 SELECT count(*) into :asd
13564 FROM Work.Gender;
WARNING: No output destinations active.
13565 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

 

 

1 REPLY 1
SASKiwi
PROC Star

Try running this statement which should open HTML output:

 

ods html;

 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 299 views
  • 0 likes
  • 2 in conversation