data crackman;
input Account_ID Revenue Segment$ N_var1 C_var1$ Transaction_Date yymmdd10. Transaction_Location$ Transaction_Code$ Transaction_Amount;
cards;
10001,5,G1,., ,2014-10-23,CHINA,APP_001,100
10002,6,G1,., ,2014-10-23,CHINA,APP_002,110
10003,6.5,G1,., ,2014-10-23,CHINA,APP_003,50
10004,10,G2,., ,2014-10-23,CHINA,APP_004,90
10005,15,G2,., ,2014-10-23,CHINA,CAN_005,12
10006,13,G2,., ,2014-10-23,CHINA,MAN_006,10000
10007,10.6,G2,., ,2014-10-23,CHINA,APP_007,10
10008,20,G3,., ,2014-10-23,CHINA,APP_008,100
10009,25,G3,., ,2014-10-23,CHINA,APP_009,200
10010,15.5,G3,., ,2014-10-23, ,REJ_010,100000
10010,15.5,G3,., ,2014-10-23, ,REJ_010,100000
10010,10.0,G4,., ,2014-10-23, ,REJ_010,100000
10010,20.0,G5,., ,2014-10-23, ,REJ_010,100000
10003,7,G1,., ,2014-10-24,CHINA,MAN_003,50000
10004,9,G2,., ,2014-10-24,CHINA,APP_004,90
10006,6,G2,., ,2014-10-24,CHINA,MAN_006,1000
10007,10.6,G2,., ,2014-10-24,CHINA,APP_007,10
10008,8,G3,., ,2014-10-24,CHINA,APP_008,100
10009,9,G3,., ,2014-10-24,CHINA,APP_009,200
10010,15.5,G3,., ,2014-10-24,CHINA,APP_010,100
10010,10,G4,., ,2014-10-24,CHINA,APP_011,101
10010,20,G5,., ,2014-10-24,CHINA,APP_012,102
;
run;
proc transpose data=crackman out=a;
var _all_;
run;
data a;
set a;
array col col1-co22;
do over col;
if col=. then delete;
end;
run;
proc transpose data=a out=crackman(drop=_name_);
var col1-col22;
run;
proc print;
run;
这是我运行的代码,不过编辑日志显示一些数据输入无效, Revenue变量是我在基于上一道题进行均值填充(按segment分类再分别计算均值然后再输入进去的),不知道是不是这样的做法有误,导致程序很多都运行不出来,输出的结果如下,对sas还处于刚入门阶段,希望有人能解答一下我的疑惑。
Obs | _NAME_ | COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |
1 | Account_ID | . | . | . | . | . | . |
2 | Revenue | . | . | . | . | . | . |
3 | Segment | 10002,6, | 10006,13 | 10010,15 | ,REJ_010 | 10006,6, | 10010,15 |
4 | N_var1 | . | . | . | . | . | . |
5 | C_var1 | 10003,6. | 10007,10 | ,REJ_010 | ,2014-10 | 10007,10 | 10010,10 |
6 | Transaction_Date | . | . | . | . | . | . |
7 | Transaction_Location | 3,CHINA, | 3,CHINA, | 10010,15 | 00000 | 4,CHINA, | 4,CHINA, |
8 | Transaction_Code | 10004,10 | 10008,20 | ,2014-10 | 10003,7, | 10008,8, | 10010,20 |
9 | Transaction_Amount | . | . | . | . | . | . |