topic Re: Enhanced Audit Logging in SAS Programming

Enhanced Audit Logging

nrk1787db1 — Wed, 21 Feb 2018 14:10:08 GMT

Hi,

Could someone please help me with below query ?

How to turn on auto audit logging feature in Base SAS for data/schema creations / modifications / deletions for data-sets in permanent libraries ?

Note : Topics related %LOG4SAS and auto-macro-call features didn't help me much with above requirement.

Example :

There is a SAS data-set named "A" in a permanent library "P1". Many users can run data/schema-alteration queries on that data-set in a given day based on appropriate access levels.

I would like to collect the activity log which contains details of any data/schema change that includes all modifications/deletions on that data-set at the end of the day so that it would be easy to track who did what.

Re: Enhanced Audit Logging

kiranv_ — Wed, 21 Feb 2018 14:31:34 GMT

here is one good paper

https://www.lexjansen.com/scsug/2009/Minh_Duong.pdf

and documentation

https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a001224397.htm

what do you think is missing in this documentation or article

Re: Enhanced Audit Logging

nrk1787db1 — Wed, 21 Feb 2018 15:03:51 GMT

Thank you

Re: Enhanced Audit Logging

AleCaro — Tue, 24 Apr 2018 00:27:10 GMT

Could you help me with a script to obtain the tables or data set that each user consults in metadata or data data in sas?