topic Knowing how long a query has been running? in SAS Enterprise Guide

Knowing how long a query has been running?

elwayfan446 — Fri, 20 Jul 2018 19:30:22 GMT

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!

Re: Knowing how long a query has been running?

ChrisHemedinger — Fri, 20 Jul 2018 19:45:30 GMT

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:

Re: Knowing how long a query has been running?

elwayfan446 — Fri, 20 Jul 2018 19:48:06 GMT

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!