BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6

ods trace on;
proc datasets lib=sashelp ;
audit class ;
run;
ods trace off ;

 

when i run the program it shows name:members on log window next......

ods output members=want;
proc datasets lib=sashelp ;
audit class ;
run;

 

 

but i can't get the dataset .

how to save audit data 

3 REPLIES 3
Jagadishkatam
Amethyst | Level 16
proc sql;
create table want as select * from dictionary.tables where libname='SASHELP';
quit;
Thanks,
Jag
Jagadishkatam
Amethyst | Level 16

alternatively use sashelp.vtable

 



data want;
set sashelp.vtable;
where libname='SASHELP';
run;
Thanks,
Jag
ballardw
Super User

If you had taken an opportunity to examine the documentation for Proc datasets you might have found as part of the AUDIT statement syntax the Details section labeled: Creating an Audit file or an Example Initiating an Audit file

Basically you have to tell SAS that you are going to perform things that the Audit is to track, which is done with an INITIATE statement.

 

Also the Audit creates a special format data set. If you didn't actually do anything then there is nothing for the "audit" to track.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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