sas动态转置问题请教

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

现在有如下数据截图

希望得到


其实在excel中就是一个pivot table就解决了，请问用sas应该怎么解决？

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：EXCEL Pivot Table ABLE xcel SAS 动态转置

我使用的是静态sql的方式实现了，但是非常麻烦，sas是否有更简单的方法？

proc sql;
create table client_yy as
select client_y.ttt,  
  sum(case when client_y.year= 'FY2015' then account3 else 0 end) as z20151,
  sum(case when client_y.year= 'FY2015' then account4 else 0 end) as z20152,  
  sum(case when client_y.year= 'FY2015' then amount1 else 0 end) as z20153,  
  sum(case when client_y.year= 'FY2015' then amount2 else 0 end) as z20154,  
  sum(case when client_y.year= 'FY2016' then account3 else 0 end) as z20161,
  sum(case when client_y.year= 'FY2016' then account4 else 0 end) as z20162,  
  sum(case when client_y.year= 'FY2016' then amount1 else 0 end) as z20163,  
  sum(case when client_y.year= 'FY2016' then amount2 else 0 end) as z20164,
  sum(case when client_y.year= 'FY2017' then account3 else 0 end) as z20171,
  sum(case when client_y.year= 'FY2017' then account4 else 0 end) as z20172,  
  sum(case when client_y.year= 'FY2017' then amount1 else 0 end) as z20173,  
  sum(case when client_y.year= 'FY2017' then amount2 else 0 end) as z20174,
  sum(case when client_y.year= 'FY2018' then account3 else 0 end) as z20181,
  sum(case when client_y.year= 'FY2018' then account4 else 0 end) as z20182,  
  sum(case when client_y.year= 'FY2018' then amount1 else 0 end) as z20183,  
  sum(case when client_y.year= 'FY2018' then amount2 else 0 end) as z20184  
from client_y
group by client_y.ttt  
order by client_y.ttt;
quit;