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
- 4369 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 |
how does sas handle missing values in procs? : Sas programming
How to convert .xls file into CSV format?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
How would you delete duplicate observations?
: and & modifiers.
Can you excute a macro within a macro? Describe.
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
What r all the reporting procedures...?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
how to generate the test data in sas without input data? : Sas-administrator
what is fact table and factless table?
What are the parameters of scan function?
Teradata 
