SAS EG: SAS Dataset is locked by opening it from EG. Need a resolution -

One of the important SAS datasets is open by our offshore Associate from SAS Enterprise Guide. We depend on that dataset for many databases through different jobs. I tried to search an option from different sites to unlock the dataset, but it has no advantage. Please provide a suggestion thank you.

Depending on some features of your situation, anyone code PW = by locking in the first place using the Dataset option:

  data myImportantTable (PW = pass 123); X = 1; Production; Run;  

Then you can create a scene that allows users to click and view the underlying data, but does not lock the original dataset:

  proc sql; See my ImagineTable_view as I select IMEPORTANTTable (read = pass123); Skip;  

Inserts, updates, etc. will now work, even if the user opens the view in EG:

  * It will also work in viewing, even if they Be opened; Proc sql; Include in my Important Table (PW = Pass 123) Value (101); Skip; Note that this is not a good option if you have many different INSERT / UPDATE statements in your program - each of them will need  (PW =). .) The  dataset option has been added to work for them.