BookmarkSubscribeRSS Feed
Asmam
Fluorite | Level 6

Hi, I am trying to know the  user ID and the code that is associated with a modification so I ran this code , but nothing is displayed

 

proc sql;
  select
         reason_code,
         _atopcode_,
         _atuserid_ format=$6.,
         _atdatetime_
         from la_prod.ADM_GLOBAL_VARS (type=audit);
quit;

someone can help me please. 

3 REPLIES 3
LinusH
Tourmaline | Level 20
Are your sure that audit is activated for this table, and that has been changes since that time?
Please provide the log.
Data never sleeps
Asmam
Fluorite | Level 6

@LinusH thanks for answering me !
Well I activated the audit and I made some changes and I add the variables _ATRETURNCODE_ , _ATMESSAGE_ .

it works for the datetime and the user name ! but i got nothing for _ATRETURNCODE_ and _ATMESSAGE_ .

 

LinusH
Tourmaline | Level 20

I can't test it right now, but my guess is that those are only populated when there is an issue, like a violated constraint or similar.

Data never sleeps

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 920 views
  • 2 likes
  • 2 in conversation