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; |
