BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
TurnTheBacon
Fluorite | Level 6

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. Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

Do you mean Metadata folders?

Proc Copy is not aware of metadata folder structure, it just copies physical tables.

Just omit the select statement.

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p04y85z9f13uaan10s1k4...

Data never sleeps

View solution in original post

2 REPLIES 2
Patrick
Opal | Level 21

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;

LinusH
Tourmaline | Level 20

Do you mean Metadata folders?

Proc Copy is not aware of metadata folder structure, it just copies physical tables.

Just omit the select statement.

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p04y85z9f13uaan10s1k4...

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 895 views
  • 3 likes
  • 3 in conversation