sas中转置
- 作者: 妹妹有点紧
- 来源: 51数据库
- 2020-09-28
下面的程序试一下吧
data test;
input ReportNo Item $ Value;
datalines;
20001 A 1.1
20001 B 1.2
20001 C 1.3
20001 D 1.4
20001 E 1.5
20002 A 2.1
20002 B 2.2
20002 C 2.3
20002 D 2.4
20002 E 2.5
;
run;
proc transpose data=test out=trans;
by ReportNo;
id Item;
run;
data test;
input ReportNo Item $ Value;
datalines;
20001 A 1.1
20001 B 1.2
20001 C 1.3
20001 D 1.4
20001 E 1.5
20002 A 2.1
20002 B 2.2
20002 C 2.3
20002 D 2.4
20002 E 2.5
;
run;
proc transpose data=test out=trans;
by ReportNo;
id Item;
run;
推荐阅读
