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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.