Interested to Buy Any Domain ? << Click Here >> for more details...
/*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
- 2 Answers
- 4453 Views
- Eval Source, I also Faced
- E-Mail Answers
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
Describe the function and utility of the most difficult SAS macro that you have written?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
What is proc sort?
Which command is used to perform sorting in sas program?
What is the difference between where and if statement?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
What makes sas stand out to be the best over other data analytics tools?
What is the maximum length of the macro variable? : sas-macro
What is maximum number of rows and cols can be handled in SAS?
What does proc print, and proc contents are used for?
How do dates work in SAS data?
What are the difference between ceil and floor functions in sas?
for what purpose would you use the retain statement? : Sas programming
what is hash files in sas and why we are using this one in sas?
Name any two sas spawners? : sas-grid-administration
