Copy Audit Files

darrylovia — Mon, 29 Mar 2010 13:49:39 GMT

Hello All,

I'm trying to make a copy of an entire library and one of my data sets has an audit file. But when I copy the table via PROC DATASETS, the audit files does not copy. See below my simple example;

data work.SHOES;
set sashelp.SHOES;
run;

proc datasets library=work nolist;
audit SHOES ;
initiate;
run;

proc datasets ;
copy in=work out=SASUSER CLONE;
select SHOES ;
quit;

4 data work.SHOES;
15 set sashelp.SHOES;
16 run;

NOTE: There were 395 observations read from the data set SASHELP.SHOES.
NOTE: The data set WORK.SHOES has 395 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

17
18 proc datasets library=work nolist;
19 audit SHOES ;
20 initiate;
WARNING: The audited data file WORK.SHOES.DATA is not password protected. Apply an ALTER
password to prevent accidental deletion or replacement of it and any associated audit
files.
21 run;

NOTE: The data set WORK.SHOES.AUDIT has 0 observations and 13 variables.
22

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

23 proc datasets ;
24 copy in=work out=SASUSER CLONE;
25 select SHOES ;
26 quit;
2 The SAS System 09:15 Monday, March 29, 2010

NOTE: Copying WORK.SHOES to SASUSER.SHOES (memtype=DATA).
WARNING: WORK.SHOES.DATA has an AUDIT file associated with it. AUDIT files will not be copied.
NOTE: There were 395 observations read from the data set WORK.SHOES.
NOTE: The data set SASUSER.SHOES has 395 observations and 7 variables.
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: Copy Audit Files

sbb — Mon, 29 Mar 2010 15:48:27 GMT

See discussion here:

Understanding an Audit Trail
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001224397.htm

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic/post:
audit file site:sas.com

Re: Copy Audit Files

darrylovia — Mon, 29 Mar 2010 16:08:24 GMT

Thanks must have missed that in the documentation.

topic Re: Copy Audit Files in SAS Procedures

Copy Audit Files

Re: Copy Audit Files

Re: Copy Audit Files