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
- 4450 Views
- Eval Source, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is the use of catalog?
Name any two sas spawners? : sas-grid-administration
what is the difference between the SAS v8 and SAS v9?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
Compare sas with other data analytics tools.
SAS System ?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
what is SAS OPTIMIZATION?
Mention what is SAS data set?
what is sas metadata repository? : Sas-bi
How would you code a merge that will keep only the observations that have matches from both sets?
Teradata 
