Moving Data Between Libraries
If you would like to move a data set from one library to another, rather than copy it, you can use the MOVE option with either Proc DATASETS or Proc COPY.
First, lets build a simple data set (TABLE1) the WORK library:
data work.table1; do i = 1 to 10; output; end; run;
Now lets move TABLE1 into the SASUSER library with Proc DATASETS:
proc datasets lib=work; copy out=sasuser move; select table1; quit;
One final example, lets move TABLE1 back into the WORK library, this time with Proc COPY:
proc copy in=sasuser out=work move; select table1; run;