What is the significance of the ‘OF’ in X=SUM (OF a1-a4,
a6, a9);?
Answers were Sorted based on User's Feedback
Answer / prag s.
IF WE DON'T USE 'OF' THEN IT WOULD BE LIKE A1(MINUS)-A4. AND
THAT'S NOT WHAT WE ARE TRYING TO ACCOMPLISH. WE ARE TRYING
TO GET THE SUM OF THE VARIABLES A1-A4...
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / rammohan
sum function adds from a1 a2 a3 a4 a6 and a9
i.e x=a1+a2+a3+a4+a6+a9
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / shraddha ganoo
When we give OF it will consider the range. i.e from a1 to
a4 and a6 and a9, if we omit OF word then the SUM function
will consider the hyphen sign (-) between a1 and a4 as a
minus sign and perform operations accordingly.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / name is no need
is the above answer is correct?can any one support the
above answer?
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sreekanth rao
to add the answer. it will consider the variables in
between a1-a4(sums all in between a1-a4)
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / xxxxxxxxxxx
if the num r in series we opt this
syntax sum (of a1-a4);
if we omit the 'of' it performs the subraction process.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / raghavendrareddy.m
it adds a1,a2,a3,a4,a6,a9:
x=sum(a1,a2,a3,a4,a6,a9);
or
x=sum(of a:);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / prem krishnan
if missing value is there in any of the varibale,if we dont
use 'of' then it will give missing value "." in the
resultant variable.
if we use 'of' then it will give the sum of the values in
rest of the variable it will consider missing value
| Is This Answer Correct ? | 1 Yes | 2 No |
what is sas and what are the functions? : Sas-administrator
what is Global Symbol table and Local symbol table?
what is Enterprise Guide?what is the use of it?
How to convert a numeric variable to a character variable?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
What are the main differences between sas versions 8.2, 9.0, 9.1?
explain about sas business intelligence? : Sas-bi
how could you generate test data with no input data? : Sas programming
What are Dashboard reports?And significance of these in analysis?
Define run-group processing?