topic SAS audit dataset in SAS Programming

SAS audit dataset

scb — Mon, 08 Oct 2018 09:55:25 GMT

May I know how to check if 'class' is an audit dataset, and not 'cars'? Is there any %sysfunc to check?

Thanks.

data class;
set sashelp.class;
run;

data cars;
set sashelp.cars;
run;

proc datasets library=work nolist nodetails;
audit class;
initiate;
quit;

s_lassen — Mon, 08 Oct 2018 10:28:57 GMT

Take a look at dictionary.tables, the variable AUDIT should tell you if an adit trail is active:

proc sql;
  select memname,audit from dictionary.tables
  where libname='WORK' and memtype='DATA';
quit;

You have to use the memtype='DATA' conditon, because there is also an 'AUDIT' type table with the name CLASS.

Ksharp — Mon, 08 Oct 2018 12:42:52 GMT

There is an option.

data want;

set class(type=audit);

run;

and also check dictionary ,

proc sql;
select * from dictionary.TABLE_CONSTRAINTS; quit;