Hi, my system currently uses scripts to run our batch jobs for EG. However we occasionally encounter table locks due to users accessing the tables therefore resulting in batch job failure. During the re-run of batch job from previous point of failure, we will then use SAS Management console to personally deny user access to the respective tables. We are currently working on the codes to be keyed in SAS EG to grant and deny access for our users through the sas scripts but we are encountering error. Can someone please assist me on how to get it started?    Keyed in this line of code in SAS EG   sas-show-metadata-access -profile Admin /DemoBranch/DemoFolder;   Error I got from this line of code is ERROR 180-322: Statement is not valid or it is used out of proper order.   When I keyed in proc sas-show-metadata-access -profile Admin /DemoBranch/DemoFolder;   Error I got from this line of code is ERROR 22-322: Syntax error, expecting one of the following: ;. AUDIT, CC, CLEANUP. ERROR 76 -322: Syntax error, statement will be ignored.   Thank You. ... View more

Hi,  Am using SAS EG 7.1. Yes I have run it before, this 'freezing' happens occassionally. I have tried to run a join on SASHELP library however when i clicked the query builder button, it freezes again. The table im trying to join only has 428 rows. CARS. I have no other issues with running queries on my other laptop. I have checked system compatibilities, both running on 64 bit and installed memory ram available is 19.9gb.   Thank you. ... View more