Copying all physical tables, but no folders, using PROC COPY

[TurnTheBacon]

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.

[Patrick]

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 · Accepted solution]

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