@ll: Thank you
You can see the code and the log below :
SAS PGM :
data toto;
w1=1;
w2='TY';
run;
%let v=(&v1., "&v2.");
%macro prog;
proc sql;
select max(w1)+1,w2 into :v1,:v2
from toto;
insert into toto
values&v;
quit;
%mend;
%prog;
SAS LOG
%let v=(&v1., "&v2."); WARNING: Apparent symbolic reference V1 not resolved. WARNING: Apparent symbolic reference V2 not resolved. %macro prog; proc sql; select max(w1)+1,w2 into :v1,:v2 from toto; insert into toto values&v; quit; %mend; %prog; NOTE: The query requires remerging summary statistics back with the original data. NOTE: 1 row was inserted into WORK.TOTO.
... View more
