Interested to Buy Any Domain ? << Click Here >> for more details...
What is the significance of the ‘OF’ in X=SUM (OF a1-a4,
a6, a9);?
- 8 Answers
- 18857 Views
- I also Faced
- E-Mail Answers
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 |
wt is a-z and a--z?
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
What SAS statements would you code to read an external raw data file to a DATA step?
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,
How does proc sql work?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What is difference between Global n Local Macro Variables..?
How is character variable converted into numeric variable and vice versa?
What is the use of divide function?
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
How can you put a "trace" in your program?
Teradata 
