Jia1Zhao 发表于 2020-12-9 10:17
这是我理解的
大神谢谢你呀,解决了我的难题,但最后有一点小bug,就是输出最终数据后,你给的图二那个表多了一个无关变量,翻译过来是"老变量的名字"是怎么回事呢?下面是我的代码
data bb(keep=sum) cc(keep=form sum1);
set Projet.Ncontrat end=obs;
by form;
sum+1;
sum1+1;
if first.form then sum1=1;
if obs then output bb;
if last.form then output cc;
run;
proc transpose data=cc out=ds_cc(drop=_name_) prefix=add;
var sum1;
id form;
run;
data final;
merge bb ds_cc;
run;