SAS audit dataset

[scb]

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]

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]

There is an option.

data want;

 set class(type=audit);

run;

and also check dictionary ,

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