求助:相同的MasterFundCode合并起来,FullName和Gender在同一行。
想要的结果:
程序:proc sql ;
create table a as select MasterFundCode , sum(FundID) as FundID ,sum(FundCompanyID) as FundCompanyID, sum(FullName) as FullName,sum(Gender) as Gender
from raw group by MasterFundCode order by MasterFundCode;
quit;
但是一直报错。是因为SUM只能加数值嘛?