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

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

More SAS Interview Questions

do you need to know if there are any missing values? : Sas programming

0 Answers  


Explain by-group processing?

0 Answers  


Mention what is SAS data set?

0 Answers  


What other SAS features do you use for error trapping and data validation?

2 Answers  


Describe the function and untility of the most difficult SAS macro that you have written.

0 Answers  






If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  


1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

9 Answers   Quintiles,


Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  


In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 Answers  


What will calendar procedure do?

0 Answers  


how can you code the confidence intervals?

6 Answers   Cytel, IIT, Ranbaxy,


what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,


Categories