/*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
Answer Posted / 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 |
Post New Answer View All Answers
Do you know the features of sas?
explain the proc in sas? : Sas-administrator
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
how does sas handle missing values in a merge? : Sas programming
Name validation tools used in SAS
what is the use of proc sql? : Sas programming
explain about various caches available in data integrator? : Sas-di
Differentiate between sas functions and sas procedures.
Explain the difference between nodup and nodupkey options?
How to specify variables to be processed by the freq procedure?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
What is the SAS data set?
Explain the difference between informat and format with an example.
What are the data types that sas contain?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?