SAS中文论坛

标题: 程序bug，求助 [打印本页]

作者: shiyiming 时间: 2006-5-14 15:04
标题: 程序bug，求助
data aa;
array x{3} x1-x3;
input x1-x3;
cards;
1 4 5
7 8 5
2 1 5
;
PROC MEANS DATA=aa;
VAR x1-x3;
OUTPUT OUT=m MEAN=mx1-mx3;
RUN;
data bb;
set aa;
set m;
do i=1 to 3;
y1=x1-mx1;y2=x2-mx2;y3=x3-mx3;
end;
run;
proc print data=bb;
run;
我希望能够输出每列元素减去该列的均值，为什么只能输出第一行呢？请大家指正，如果用宏应该怎么编写呢？

作者: shiyiming 时间: 2006-5-14 20:37
标题: zzzzz
[code:83ee0]
proc sql noprint;
create table cc as
select x1-mean(x1) as y1,x2-mean(x2) as y2,x3-mean(x3) as y3
from aa;
quit;[/code:83ee0]

[code:83ee0]
data bb(keep=y1-y3);
set m;
do i=1 to 3;
set aa point=i;
y1=x1-mx1;y2=x2-mx2;y3=x3-mx3; output;
end;
run;
[/code:83ee0]

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)