What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

What is the significance of the ‘OF’ in X=SUM (OF a1-a4,
a6, a9);?

Question Posted / guest

8 Answers
16324 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);? ..

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

Post New Answer