🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 06-10-2015 03:08 PM
(1179 views)
Hi,
i want sum of first 5 obs(1-5) then sum of next five obs(2-6) and so on...
data have;
input obs var1;
cards;
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 20
run;
Thanks..
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You didn't post the output you need yet .
Code: Program
data have;
input obs var1;
cards;
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 20
;
run;
proc sql;
create table want as
select *,(select sum(var1) from have where obs between a.obs and a.obs+4) as sum
from have as a;
quit;
Xia Keshan
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data have;
input obs var1;
lag1=lag(var1);
lag2=lag2(var1);
lag3=lag3(var1);
lag4=lag4(var1);
sum_of_five=sum(var1,lag1,lag2,lag3,lag4);
cards;
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 20
run;
--
Paige Miller
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Just to add a little variety:
sum_of_five + var1;
back5 = lag5(var1);
if back5 > . then sum_of_five = sum_of_five - back5;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You didn't post the output you need yet .
Code: Program
data have;
input obs var1;
cards;
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 20
;
run;
proc sql;
create table want as
select *,(select sum(var1) from have where obs between a.obs and a.obs+4) as sum
from have as a;
quit;
Xia Keshan
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content