I think my brute force approach would be to modify the programs use %let macro variables to capture the userID and production date and time. jobName would have to be hardcoded. Use proc printto to redirect the log to an external file. When the job finishes turn off proc printto and have it run a data step (but I'd put it in a macro) that reads in the external log file with each line as a single long character variable. Be sure to use the end= data set option so you know when you've reached the last record. Either substring or index each line looking for the phrases 'real time' and 'cpu time' and parse them when found to get the values. Sum those values and carry the values forward using a Retain statement. When you've reached the last line in the log file then calculate the ratio and write the macro variable values, the totals, and the ratio as a record to your database.
... View more