topic how to save data in SAS Programming

how to save data

thanikondharish — Sun, 16 Sep 2018 03:38:05 GMT

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

Re: how to save data

Jagadishkatam — Sun, 16 Sep 2018 05:45:59 GMT

proc sql;
create table want as select * from dictionary.tables where libname='SASHELP';
quit;

Re: how to save data

Jagadishkatam — Sun, 16 Sep 2018 05:51:01 GMT

alternatively use sashelp.vtable



data want;
set sashelp.vtable;
where libname='SASHELP';
run;

Re: how to save data

ballardw — Mon, 17 Sep 2018 17:49:26 GMT

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.