When you try to re-create a table that already exists using SAS code, the following error might occur:

ERROR: You cannot open WORK.XXX.DATA for output access with member-level control because WORK.XXX.DATA is in use by you in resource environment Compute Server.

This issue occurs in SAS^® Enterprise Guide^® 8.4 or SAS^® Enterprise Guide^® 8.5 in environments running the SAS Viya platform. 

This issue occurs when you complete steps similar to the following:

1. Open SAS Enterprise Guide and connect to your SAS Viya platform environment.
2. Create or open an existing SAS data set.
3. From the table viewer, use the WHERE button to apply a filter to the table.
4. Run SAS code to re-create the table. The error occurs.

Note that the error occurs even if the table is no longer opened in the table viewer.

To address this issue, try the following workarounds:

• Close SAS Enterprise Guide and restart it.
• Use a new name for the SAS data set.
• Avoid using the interactive WHERE clause.

This issue is fixed in SAS^® Enterprise Guide^® 8.6.