BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nrk1787db1
Obsidian | Level 7

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
kiranv_
Rhodochrosite | Level 12

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

 

View solution in original post

3 REPLIES 3
kiranv_
Rhodochrosite | Level 12

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

 

nrk1787db1
Obsidian | Level 7

Thank you

AleCaro
Calcite | Level 5
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?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 895 views
  • 0 likes
  • 3 in conversation