BookmarkSubscribeRSS Feed
learn_SAS_23
Pyrite | Level 9

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
4 REPLIES 4
ChrisHemedinger
Community Manager

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.

 

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
learn_SAS_23
Pyrite | Level 9

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

 

Tom
Super User Tom
Super User

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1807 views
  • 3 likes
  • 4 in conversation