Date:         Wed, 14 Mar 2012 19:46:43 -0400
Reply-To:     bbser 2009 <bbser2009@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bbser 2009 <bbser2009@GMAIL.COM>
Subject:      Re: user_var variables from audit trial
Content-Type: text/plain; charset="us-ascii"

I just found another way to evaluate a user_var variable from audit trial.
Let me just put it here.

data one;
x=1;
run;

data two;
x=2;
who='Max';
run;

proc datasets nolist;
  audit one;
  initiate;
  user_var who $20 label='Who made the change';
quit;

proc sql;
insert into one (x,who)
select *
from two;

select *
from one(type=audit);
quit;

-----Original Message-----
From: bbser 2009 [mailto:bbser2009@gmail.com]
Sent: March-13-12 11:33 PM
To: 'SAS-L@LISTSERV.UGA.EDU'
Subject: user_var variables from audit trial

Hi there,

I did not get much info about how to give/change values to user_var
variables from audit trial.
I just got a feeling that the unique way to do this is to use a data step
powered by a modify statement, like the code shows below.
Could you please tell me more about this? Thank you.


Regards, Max
(Maaxx)

data one;
x=1;
run;
proc datasets nolist;
  audit one;
  initiate;
  user_var who $20 label='Who made the change';
quit;

data one;
modify one;
who='Max';
run;

proc print data=one(type=audit);run;