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
proc sql;
create table want as select * from dictionary.tables where libname='SASHELP';
quit;
alternatively use sashelp.vtable
data want;
set sashelp.vtable;
where libname='SASHELP';
run;
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.
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!
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.
Ready to level-up your skills? Choose your own adventure.