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;

 

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 384 views
  • 0 likes
  • 2 in conversation