p***7 发帖数: 535 | 1 The Y value needs to be sumed up from 1 to 6 in 'order' variable. How can
I do it?
I think to create one additional variable by concanating variable A and
variable B, Then do group sum up. Please help me out.
Y A B ORDER
21.0 1 1 1
23.0 1 1 2
19.0 1 1 3
22.0 1 1 4
22.0 1 1 5
23.0 1 1 6
21.0 1 2 1
22.0 1 2 2
20.0 1 2 3
21.0 1 2 4
19.0 1 2 5
25.0 1 2 6
Thanksssss! |
w*******e 发帖数: 182 | 2 data one;
input Y A B ORDER;
cards;
21.0 1 1 1
23.0 1 1 2
19.0 1 1 3
22.0 1 1 4
22.0 1 1 5
23.0 1 1 6
21.0 1 2 1
22.0 1 2 2
20.0 1 2 3
21.0 1 2 4
19.0 1 2 5
25.0 1 2 6
run;
proc print data=one;
run;
data one;
set one;
AB=10*A+B;
drop A B;
run;
proc sql;
CREATE TABLE TWO AS
SELECT SUM(Y) as SUMY,AB
FROM ONE
GROUP BY AB;
QUIT;
proc print data=two;
run;
can
【在 p***7 的大作中提到】 : The Y value needs to be sumed up from 1 to 6 in 'order' variable. How can : I do it? : I think to create one additional variable by concanating variable A and : variable B, Then do group sum up. Please help me out. : Y A B ORDER : 21.0 1 1 1 : 23.0 1 1 2 : 19.0 1 1 3 : 22.0 1 1 4 : 22.0 1 1 5
|
p***7 发帖数: 535 | |
w*******e 发帖数: 182 | 4 你的来美九年记快更新啊。我比你晚来美国没几年,才刚开始工作,房子远远无望。
【在 p***7 的大作中提到】 : My superhero! Thanks!
|
J******d 发帖数: 287 | 5 proc means;
class B;
var Y;
output out=xx sum=xx;
run;
can
【在 p***7 的大作中提到】 : My superhero! Thanks!
|
t********m 发帖数: 939 | 6 proc summary data=one;
class A B;
var y;
output out=sumy sum=;
run;
data final;
set sumy(where=(_TYPE_=3));
run;
proc print data=final;
run;
can
【在 p***7 的大作中提到】 : My superhero! Thanks!
|
p***7 发帖数: 535 | 7 Come on, I have been in U.S.A for 2 years. I can have 来美2年记.
【在 w*******e 的大作中提到】 : 你的来美九年记快更新啊。我比你晚来美国没几年,才刚开始工作,房子远远无望。
|
m**s 发帖数: 71 | 8 assuming no missing data, ie, all 6 orders are present:
data tmp;
set yourdata;
retain total;
if order = 1 then total = 0;
total + y;
if order = 6;
run; |