topic Audit trail in SAS Programming

Audit trail

Saszealot — Fri, 15 May 2009 21:37:29 GMT

Is it possible to initiate an audit trail at the same time creating a SAS data set?
If yes how?
Thanks.

Re: Audit trail

sbb — Fri, 15 May 2009 22:02:18 GMT

Can you be more specific to your interest level for audit trail? File-level, column- or row-level, SAS variable attribute changes, SAS program impact changes? The SAS system does have some versioning, however much (or little) would need to be implemented through the SAS application itself, rather than expecting some action to occur with the SAS system. Any type of transaction management recovery or roll-back technique would need to be engineered within the SAS application.

You may find useful technical reference and supplemental conference papers on the topic, using the SEARCH facility or with a Google advanced search against the SAS.COM site.

Scott Barry
SBBWorks, Inc.

Better SAS® Programming Through Version Control
Tim Williams, PRA International, Charlottesville, VA
http://www2.sas.com/proceedings/forum2007/006-2007.pdf

Re: Audit trail

Peter_C — Sat, 16 May 2009 15:55:06 GMT

perhaps.
certainly, integrity constraints can be added only after the data set exists. However, you can add to a preexisting data set with sql insert, append and data step modify, subjecting new rows to the integrity constraints.

peterC