BookmarkSubscribeRSS Feed
darrylovia
Quartz | Level 8
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
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
darrylovia
Quartz | Level 8
Thanks must have missed that in the documentation.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 2 replies
  • 787 views
  • 0 likes
  • 2 in conversation