作者bcs (= ="frailty..gggg XD)
看板Statistics
标题[程式] SAS的转置
时间Fri Oct 9 22:09:23 2009
[软体程式类别]:
SAS
[程式问题]:
资料处理
[软体熟悉度]:
中(3个月到1年)
[问题叙述]:
最後一步的PROC TRANSPOSE，我想要把资料one变成的格式是：
YR MX1_1 MX1_2 MX2_1 MX2_2....
试了几次的PROC TRANSPOSE，却一直转到WIDE TO LONG的格式
请问该怎麽下语法才能让资料one转成LONG TO WIDE ?
谢谢
[程式范例]:
data one;
input yr sex $ group x1 x2 x3 x4;
cards;
1979 F 1 0.024 0.042 0.058 0.249
1979 F 2 0.034 0.050 0.054 0.406
1979 M 1 0.029 0.039 0.058 0.748
1979 M 2 0.028 0.038 0.040 0.598
1980 F 1 0.021 0.030 0.038 0.247
1980 F 2 0.039 0.053 0.055 0.413
1980 M 1 0.026 0.035 0.046 0.748
1980 M 2 0.027 0.035 0.036 0.601
1981 F 1 0.017 0.022 0.032 0.235
1981 F 2 0.036 0.051 0.054 0.419
1981 M 1 0.020 0.027 0.045 0.745
1981 M 2 0.022 0.030 0.032 0.610
1982 F 1 0.031 0.040 0.065 0.232
1982 F 2 0.047 0.065 0.073 0.414
1982 M 1 0.040 0.051 0.098 0.732
1982 M 2 0.049 0.059 0.064 0.582
;
run;
PROC MEANS DATA=ONE NOPRINT;
BY YR GROUP;
VAR X1-X4;
WHERE SEX="M";
OUTPUT OUT=MK(DROP = _TYPE_ _FREQ_) MEAN=MX1 -MX4;
RUN;
PROC MEANS DATA=K1;
BY YR;
VAR MX1-MX4;
OUTPUT OUT=MK(DROP=_TYPE_ _FREQ_) MEAN=XMX
PROC MEANS DATA=ONE;
BY YR GROUP;
VAR X1-X4;
WHERE SEX="F";
OUTPUT OUT=FK(DROP = _TYPE_ _FREQ_) MEAN=FX1 -FX4;
RUN;
DATA K1;
MERGE FK MK;
BY YR;
RUN;
PROC SORT DATA=K1;BY GROUP;RUN;
PROC TRANSPOSE DATA=K1 OUT=K2;
BY GROUP ;
VAR FX1-FX4 MX1-MX4;
RUN;
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.112.86.136
※ 编辑: bcs 来自: 140.112.86.136 (10/09 22:11)
※ 编辑: bcs 来自: 140.112.86.136 (10/09 22:12)