topic Re: Copying all physical tables, but no folders, using PROC COPY in SAS Data Management

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

TurnTheBacon — Wed, 07 Nov 2012 10:00:58 GMT

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.

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

Patrick — Wed, 07 Nov 2012 10:24:58 GMT

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;

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

LinusH — Wed, 07 Nov 2012 10:27:04 GMT

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#p04y85z9f13uaan10s1k40ptx6gs.htm