/*i have the following dataset.*/ data score; input marks ; datalines; 10

/*i have the following dataset.*/

data score;
input marks ;
datalines;
10
20
30
40
50
60
70
80
90
100
;
run;

Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150
and 2 to 6 i.e(20+30+40+50+60)=200
and 3 to 7 i.e(30+40+50+60+70)=250 and so on.
how to get it.
thanks in advance

Question Posted / raju

2 Answers
3449 Views
Eval Source, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 ..

Answer / naveen kumar

proc transpose data=score out=score2 prefix= mark;
var marks;
quit;

data score2;
set score2;
sum1=sum(mark1,mark2,mark3,mark4,mark5);
sum2=sum(mark2,mark3,mark4,mark5,mark6);
sum3=sum(mark3,mark4,mark5,mark6,mark7);
sum4=sum(mark4,mark5,mark6,mark7,mark8);
sum5=sum(mark5,mark6,mark7,mark8,mark9);
sum6=sum(mark6,mark7,mark8,mark9,mark10);
run;

Is This Answer Correct ?

4 Yes

0 No

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 ..

Answer / tandon

PROC TRANSPOSE DATA=SCORE OUT=SCORE2 NAME=SUBJECT PREFIX=MARKS;
VAR MARKS;
RUN;

PROC PRINT DATA=SCORE2;
RUN;

DATA SUM;
SET SCORE2;
A=SUM(OF MARKS1 - MARKS5);
B=SUM(OF MARKS2 - MARKS6);
C=SUM(OF MARKS3 - MARKS7);
D=SUM(OF MARKS4 - MARKS8);
E=SUM(OF MARKS5 - MARKS10);
RUN;
PROC PRINT DATA=SUM HEADING=H;
OPTIONS LS=150;
RUN;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer