SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

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

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


Accepted Solutions
Solution
‎11-07-2012 05:27 AM
Super User
Posts: 5,429

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

Posted in reply to TurnTheBacon

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


All Replies
Respected Advisor
Posts: 4,173

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

Posted in reply to TurnTheBacon

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;

Solution
‎11-07-2012 05:27 AM
Super User
Posts: 5,429

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

Posted in reply to TurnTheBacon

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
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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