原始数据集exp5_1;
最终生成数据集new的格式为:
gender enzyme subj y1 y2 y3 y4 y5 y6
1 1 1 19 22 28 16 26 22
目前只能生成数据集y(只有y1-y3),
请问如何通过transpose生成new数据集?
data exp5_1;
do gender = 1 to 2;
do subj = 1 to 8;
do enzyme = 1 to 2;
do lever = 1 to 3;
input y @@;
output;
end;
end;
end;
end;
cards;
19 22 28 16 26 22
11 19 30 12 18 28
20 24 24 24 22 29
21 25 25 15 10 26
18 24 29 19 26 28
17 23 28 15 23 22
20 23 23 26 21 28
14 20 29 25 29 29
16 20 24 30 34 36
26 26 26 24 30 32
22 27 23 33 36 45
16 18 29 27 26 34
19 21 20 22 22 21
20 25 25 29 29 33
21 22 23 27 26 35
17 20 22 23 26 28
;
run;
proc sort data=exp5_1;
by GENDER enzyme subj;
run;
proc transpose data=exp5_1 out=y(rename=(_1 = y1 _2 =y2 _3=y3 _4=y4 _5=y5 _6=y6)); *lever只有3个水平;
by GENDER enzyme subj;
id lever;
run;