Knowing how long a query has been running?

[elwayfan446]

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!

[ChrisHemedinger · Accepted solution]

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:

[elwayfan446]

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!