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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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