https://communities.sas.com/t5/SAS-Enterprise-Guide/error-while-target-table-from-source-with-proc-sql/m-p/404193#M25938 <P>&nbsp;</P><P>&nbsp;</P><P>ERROR: You cannot reopen WORK.TEST.DATA for update access with member-level control because WORK.TEST.DATA is in use by you in<BR />resource environment SQL (2).<BR />ERROR: PROC SQL could not undo this statement if an ERROR were to happen as it could not obtain exclusive access to the data set.<BR />This statement will not execute as the SQL option UNDO_POLICY=REQUIRED is in effect.<BR />NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.</P> Sat, 14 Oct 2017 04:16:18 GMT akash_wankh 2017-10-14T04:16:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/error-while-target-table-from-source-with-proc-sql/m-p/404193#M25938 <P>&nbsp;</P><P>&nbsp;</P><P>ERROR: You cannot reopen WORK.TEST.DATA for update access with member-level control because WORK.TEST.DATA is in use by you in<BR />resource environment SQL (2).<BR />ERROR: PROC SQL could not undo this statement if an ERROR were to happen as it could not obtain exclusive access to the data set.<BR />This statement will not execute as the SQL option UNDO_POLICY=REQUIRED is in effect.<BR />NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.</P> Sat, 14 Oct 2017 04:16:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/error-while-target-table-from-source-with-proc-sql/m-p/404193#M25938 akash_wankh 2017-10-14T04:16:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/error-while-target-table-from-source-with-proc-sql/m-p/404194#M25939 <P>Usually happens when a subquery references the same table that you are trying to update.</P> Sat, 14 Oct 2017 04:37:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/error-while-target-table-from-source-with-proc-sql/m-p/404194#M25939 PGStats 2017-10-14T04:37:26Z