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
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.
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
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
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.
Then you should first migrate your datasets to your current environment before trying to activate the audit trail.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.