07-20-2018 03:30 PM
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.
07-20-2018 03:45 PM
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: