The code is shown below:
%macro append;
DATA sample.export;
%clipboard;
Run;
PROC APPEND BASE=sample.export1 DATA=sample.export FORCE;
run;
%mend append;
%let vara=&TestProp;
%macro merge(num);
%do _i_ = 1 %to #
data _null_;
slept = sleep(10);
run;
%append
%end;
%mend merge;
%merge(&vara)
each time I hope to get variables'value from clipboard and add into summary sheet. But how to control the break time, then I can tab to Excel Windows to copy data, and go to next copy after entering or inputing something.
%macro append;
DATA sample.export;
%clipboard;
Run;
PROC APPEND BASE=sample.export1 DATA=sample.export FORCE;
run;
%mend append;
%let vara=&TestProp;
%macro merge(num);
%do _i_ = 1 %to #
data _null_;
slept = sleep(10);
run;
%append
%end;
%mend merge;
%merge(&vara)
each time I hope to get variables'value from clipboard and add into summary sheet. But how to control the break time, then I can tab to Excel Windows to copy data, and go to next copy after entering or inputing something.