BookmarkSubscribeRSS Feed
learn_SAS_23
Quartz | Level 8

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.

 

 

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
learn_SAS_23
Quartz | Level 8

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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