topic Re: sum for required obs in New SAS User

sum for required obs

BrahmanandaRao — Thu, 16 May 2019 04:54:58 GMT

/*Find the sum of all marks from id 3 to id 8 by using Datastep*/

data cal;
file print;
input id marks;
cards;
1 97
2 95
3 45
4 54
5 45
6 48
7 47
8 47
9 45
10 58
;
run;

data cal1 ;
set cal;
do id= 3 to 8
r=sum(of 3,4,5,6,7,8);
run;

Re: sum for required obs

PeterClemmensen — Thu, 16 May 2019 06:35:00 GMT

data want;  
   set cal;
   if 3 le id le 8 then do;
      r+marks;
   end;
run;

Re: sum for required obs

BrahmanandaRao — Thu, 16 May 2019 06:39:24 GMT

HI Draycut

i donot want to cumulative sum

just total sum from id 3 to id 8 only

Regards,

ANAND

Re: sum for required obs

PeterClemmensen — Thu, 16 May 2019 06:41:11 GMT

data cal;
input id marks;
cards;
1 97
2 95
3 45
4 54
5 45
6 48
7 47
8 47
9 45
10 58
;
run;

data want;  
   set cal end=lr;
   if 3 le id le 8 then do;
      r+marks;
   end;
   if lr then output;
   keep r;
run;

proc print;
run;

Re: sum for required obs

BrahmanandaRao — Thu, 16 May 2019 06:47:14 GMT

HI Draycut

Brilliant code thank you for your tremendous response

Regards,

ANAND

Re: sum for required obs

ballardw — Thu, 16 May 2019 17:03:31 GMT

And another approach:

proc means data=cal sum;
   where 3 le id le 8;
   var marks;
run;