很感謝你們幫我呢..已作出修正!! .不過到macro時我想update時..
不過仍然是2列數據還是分開..可幫一下我嘛...謝!!!!


%macro a(a1=);
data p2Q5;
set &a1;
ppy=y;
run;
%mend a;
%macro b(b1=);
data p1Q5;
set &b1;
ppy=py;
run;
%mend b;

%macro c(c1=,c2=);
data  pQ5;
update  &c1 &c2;
by yr;
run;
%mend c;

%a(a1=Q4);
%b(b1=Q4);
%c(c1=%b,c2=%a);

proc print;

run;