I have tested that the following code successfully copies the physical table "Employee" from Lib1 to Lib2. However, I need to edit the code so that it copies all the physical tables in that location, but not the folders. How can I accomplish this?
proc copy in = Lib1 out= Lib2 index=yes constraint=yes;
select Employee;
quit;
Thanks for your time.
Do you mean Metadata folders?
Proc Copy is not aware of metadata folder structure, it just copies physical tables.
Just omit the select statement.
PROC COPY is a subset of PROC DATASETS. Here the code using PROC DATASETS
proc datasets nolist nowarn;
copy in=Lib1 out=Lib2
clone
datecopy
force
index=yes
constraint=yes
memtype=(data)
;
run;
quit;
Do you mean Metadata folders?
Proc Copy is not aware of metadata folder structure, it just copies physical tables.
Just omit the select statement.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.