This copy procedure is useful for copying SAS data library entries from one device to another. We can copy whole SAS data Sets from one library to another (or) select the members which we want to copy.
Syntax:-
PROC COPY IN = LIBNAME OUT = LIBNAME <OPTIONS>;
SELECT MEMBER – LIST;
EXCLUDE MEMBER – LIST;
RUN;

In = Libname: – Refers the SAS library containing the members that are to be copied.
Out= Libname: – Refers to the SAS library into which members are copied.
Select: – Select the member type will be processed by proc copy.
Exclude: – Select the member type will not be processed by proc copy

Examples:-
Libname RK “D:\STANSYS\SAS\LIBRARY”;
Libname RAM “E:\ STANSYS\SAS\LIBRARY”;
Create RK Library and store some datasets in RK library.
Copy/Exclude those datasets from RK library to Ram library.
PROC COPY IN= RK OUT = RAM;
SELECT DEMO1 DEMO5;
RUN;
PROC COPY IN= RK OUT = RAM;
EXCLUDE DEMO2 DEMO5;
RUN;
Option:-
Memtype=Data |View |All: – Specify member types which you want to copy like DATA, VIEW, or ALL, which includes DATA and VIEW.
PROC COPY IN= RK OUT = RAM MEMTYPE=VIEW;
EXCLUDE DEMO2 DEMO5;
RUN;

Just it copy’s datasets, so it’s available in existing library also.