topic Re: How to get history of changes to a sas dataset in SAS Programming

How to get history of changes to a sas dataset

learn_SAS_23 — Thu, 20 Oct 2022 14:23:18 GMT

Hello Team,

I am trying to create audit trail for a sas dataset , where am getting below error.

is there any other way , to get history of changes done to a sas data set

proc datasets library=test_library nolist;
audit PARAMETERS;
initiate;
quit;

28         proc datasets library=test_library nolist;
29         audit PARAMETERS;
30         initiate;
ERROR: Requested function is not supported.
31         quit;

NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds

Re: How to get history of changes to a sas dataset

ChrisHemedinger — Thu, 20 Oct 2022 15:41:52 GMT

Audit files are supported only for Base SAS engine files. If your data set is in a database, SPDE library, or even a META (metadata based) library, this function is not supported.

See Understanding an Audit Trail in the SAS documentation. You would typically also supply an ALTER password when initiating the AUDIT function.

Re: How to get history of changes to a sas dataset

learn_SAS_23 — Thu, 20 Oct 2022 17:36:08 GMT

Thanks @ChrisHemedinger for the links , Yes we are storing the sas datasets in Unix environment

By this documentation Audit trail for sas data set are not supported .

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/n0ndg2uekz7qkbn1caoki2hzqx8l.htm

Audit Trails and CEDA Processing

When a SAS data file requires processing with , audit trails are not supported. For example, CEDA translates the file for you if you transfer a SAS data file with an initiated audit trail from one operating environment such as Windows to a different operating environment such as UNIX. However, the audit trail is not available

Re: How to get history of changes to a sas dataset

Tom — Thu, 20 Oct 2022 17:38:52 GMT

That does not say audit does not work for SAS datasets. It just says trying to read the file using a different environment in which it was created will not allow you to access the audit trial. Or in other words the feature, CEDA, that allows you to read dataset created on a different version of SAS does not support accessing the audit trail.

Re: How to get history of changes to a sas dataset

Kurt_Bremser — Fri, 21 Oct 2022 10:31:33 GMT

Then you should first migrate your datasets to your current environment before trying to activate the audit trail.