https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34257#M8331 can u send me the script? Thu, 31 Dec 2009 18:24:30 GMT HM3 2009-12-31T18:24:30Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34250#M8324 When a statement is submitted, I want to include Real time or CPU time in the footnote.How to go about it? Wed, 23 Dec 2009 12:41:58 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34250#M8324 HM3 2009-12-23T12:41:58Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34251#M8325 You can use the SAS system option ALTLOG to capture a copy of the SAS log output to a file, and specify the FULLSTIMER option to reveal detailed statistics in the log. Then use a DATA step to parse the ALTLOG file, capturing the desired metrics. And lastly you will need to generate SAS macro variable(s) containing these SAS execution metrics.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 23 Dec 2009 15:08:55 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34251#M8325 sbb 2009-12-23T15:08:55Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34252#M8326 Scott<BR /> are you able to open the altlog (to parse it) before the session closesp Wed, 23 Dec 2009 16:30:01 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34252#M8326 Peter_C 2009-12-23T16:30:01Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34253#M8327 It appears that you cannot.<BR /> <BR /> [pre]<BR /> 40 data _null_;<BR /> 41 infile "%sysfunc(getoption(altlog))";<BR /> 42 input;<BR /> 43 list;<BR /> 44 run;<BR /> <BR /> ERROR: File is in use, C:\Documents and Settings\datanull\My Documents\My SAS Files\9.1\ALT.log.<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> [/pre]<BR /> <BR /> Then there is our old friend PROC PRINTTO. Wed, 23 Dec 2009 18:00:20 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34253#M8327 data_null__ 2009-12-23T18:00:20Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34254#M8328 data _null_ is correct - disregard my post-reply about using ALTLOG - that is if you want to parse the current session's log.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 23 Dec 2009 18:32:06 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34254#M8328 sbb 2009-12-23T18:32:06Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34255#M8329 data null ;<BR /> that was my expectation.<BR /> I'm surprised Scott neither suggested proc printto, nor the more interesting proc scaproc (which might be able to collect also the cpu times iirc - if you have sas92) Wed, 23 Dec 2009 18:41:59 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34255#M8329 Peter_C 2009-12-23T18:41:59Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34256#M8330 sorry about my wishful thinking<BR /> apparently proc scaproc reports elapse time, not CPU Wed, 23 Dec 2009 19:14:13 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34256#M8330 Peter_C 2009-12-23T19:14:13Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34257#M8331 can u send me the script? Thu, 31 Dec 2009 18:24:30 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34257#M8331 HM3 2009-12-31T18:24:30Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34258#M8332 Please share the script Thu, 31 Dec 2009 18:26:06 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34258#M8332 HM3 2009-12-31T18:26:06Z https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34259#M8333 to what script do you refer Thu, 31 Dec 2009 19:39:15 GMT https://communities.sas.com/t5/SAS-Procedures/Time-to-execute-on-Footnote/m-p/34259#M8333 Peter_C 2009-12-31T19:39:15Z