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!
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:
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:
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!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.