纵向合并,variable 名字都一样的.
现在是用macro 写了一个循环:
%macro stack;
%do i=1 %to &number
proc append base = clean._1 data = clean._&i ;
run;
%end;
%mend;
但是append有一个问题,就是要把他们的length统一起来
%do i =1 %to &number
data clean._&i;
length author_1_by_1 $200;
length authors $200;
length title $200;
length name $200;
set clean._&i;
run;
%end;
现在问题是,想用data 步写循环把他们用set 一起粘起来
类似于:
data all_data;
set clean._1 clean._2 clean._3 clean._4 ......
run;
有什么办法吗?谢谢!