How to stop during the loop to assign new value to variables

[on818come]

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.

 

[on818come]

Another foolish question, why I can't input character variable from keyboard by %windows macro, I can only input numbers.

%window dialoguewindow
icolumn=15
irow=10
columns=80
rows=20
"<Creat a summary sheet>"
#3 @20 "Adjusted Table Format"
#5 @15 "please enter information of tables"
#7 @15 "The Testing Property" @40 TestProp 6
ATTR=UNDERLINE REQUIRED=YES
#9 @15 "The Environment" @40 Env 6
ATTR=UNDERLINE REQUIRED=YES
#11 @15 "Plies Number" @40 PliesNum 6
ATTR=UNDERLINE REQUIRED=YES
#13 @15 "Other Parameters" @40 OtherPara 1
ATTR=UNDERLINE REQUIRED=YES
;