https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71668#M15512 Hi,<BR /> I am writing a macro which will try to lock the dataset using LOCK DS_name command. If due to contention the Lock fails then we need to trigger an email which will contain details about the user/process holding the lock on given table. By using LOCK DS_name LIST we can know this but these details from LOCK LIST get written into Log file. Is there any way to redirect output of this command to some dataset which we can use for sending an email.<BR /> <BR /> Regards,<BR /> Amol Deshmukh Thu, 29 Jan 2009 15:01:12 GMT dav_amol 2009-01-29T15:01:12Z https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71668#M15512 Hi,<BR /> I am writing a macro which will try to lock the dataset using LOCK DS_name command. If due to contention the Lock fails then we need to trigger an email which will contain details about the user/process holding the lock on given table. By using LOCK DS_name LIST we can know this but these details from LOCK LIST get written into Log file. Is there any way to redirect output of this command to some dataset which we can use for sending an email.<BR /> <BR /> Regards,<BR /> Amol Deshmukh Thu, 29 Jan 2009 15:01:12 GMT https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71668#M15512 dav_amol 2009-01-29T15:01:12Z https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71669#M15513 SAS 9.2 discussion should lend some guidance. You can use a macro to interrogate the LOCK return code, and then decide what course to take regarding an EMAIL, with condition %IF %THEN %DO / %END code.<BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SAS/Share 9.2 DOC: Locking Objects Explicitly (LOCK Statement)<BR /> <A href="http://support.sas.com/documentation/cdl/en/shrref/59595/HTML/default/a000203048.htm" target="_blank">http://support.sas.com/documentation/cdl/en/shrref/59595/HTML/default/a000203048.htm</A> Thu, 29 Jan 2009 20:01:29 GMT https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71669#M15513 sbb 2009-01-29T20:01:29Z https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71670#M15514 have a look at ROC PRINTTO.<BR /> That will redirect the log to a file from which you can read the messages.<BR /> <BR /> good luck<BR /> <BR /> PeterC Thu, 29 Jan 2009 20:01:41 GMT https://communities.sas.com/t5/SAS-Programming/redirecting-the-output-of-LOCK-LIST-to-output-file-insead-of-Log/m-p/71670#M15514 deleted_user 2009-01-29T20:01:41Z