Desktop productivity for business analysts and programmers

Knowing how long a query has been running?

Reply
Regular Contributor
Posts: 163

Knowing how long a query has been running?

Hello,

 

I am a heavy user of SAS EG and I am trying to figure out if there is a way to tell how long a query has been running while it is still running?  I have a Microsoft SQL background and in SSMS there is a query timer when you run one.  Just wondering if anyone has come up with a way to do that withing SAS, or PROC SQL.

 

Thanks!

Community Manager
Posts: 3,467

Re: Knowing how long a query has been running?

Posted in reply to elwayfan446

You could instrument your PROC SQL with a SYSECHO statement:

 

proc sql;
 sysecho "Starting query at %sysfunc(datetime(),datetime20.)";
 create table foo
  as select 
    sleep(2,1) as a,
    * from sashelp.class;
quit;

Task status view:

timer.png

 

 

Regular Contributor
Posts: 163

Re: Knowing how long a query has been running?

Posted in reply to ChrisHemedinger

That is a good idea.  I wish I would have thought of that before I started the one I am waiting on right now.  Ugh.  Thanks!

Ask a Question
Discussion stats
  • 2 replies
  • 105 views
  • 1 like
  • 2 in conversation