proc sql;
create table b as select *, (case when count(code) > 1 then 1 else 0)as n,(case when count(code)=1 then 0 alse count(code)) as m from a group by t,code ; run;
上面写的有问题
proc sql;
create table b as select *, (case when count(code) > 1 then 1 else 0 end )as n,(case when count(code)=1 then 0 alse count(code) end ) as m from a group by t,x ; run;
只有一年的话 就没必要 by t 上面写的有问题