请教:这样的数据如何转换?
做重复资料的方差分析,程序如下:
proc
glm
data=repeat;
class cn group;
model p05a05h1 p05a1h1 p05a2h1 p05a4h1 p05a6h1 p05a8h1 p05a10h1 p05a12h1 p05a14h1 p05a18h1=group p05a00h1 p03heigh p03weigh sex cn/nouni
ss3;
repeated time/printe;
means group;
ods
output means=mean;
run;quit;
生成mean库为:effect
| group
| N
| Mean_p05a05h1
| sd_p05a05h1
|
| Mean_p05a00h1
| sd_p05a00h1
| …
|
Group
| A
| 116
| 4.26724
| 1.94425
| …
| 6.3362
| 1.31839
| …
|
group
| B
| 115
| 4.04347
| 2.12912
| …
| 6.6521
| 1.30480
| …
|
库mean的变量为mean_各时点数据和sd_各时点数据,时点数和协变量不同,生成库的变量个数不同。我想得到如下表所示的格式数据,不知道如何实现?附上数据库repeat,请各位朋友帮忙,谢谢!
| mean | sd |
A | B | A | B |
N | 116 | 115 | | |
p05a05h1 | 4.26724 | 4.04347 | 1.94425 | 2.12912 |
… | … | … | … | … |
p05a00h1 | 6.3362 | 6.6521 | 1.31839 | 1.30480 |
… | … | … | … | … |