Help using Base SAS procedures

Copy Audit Files

Reply
Frequent Contributor
Posts: 139

Copy Audit Files

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Copy Audit Files

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
Frequent Contributor
Posts: 139

Re: Copy Audit Files

Thanks must have missed that in the documentation.
Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 2 in conversation