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
- 18442 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 |
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
How do you write a test plan?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
what versions of sas have you used (on which platforms)? : Sas programming
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
what is p-value
3 Answers Accenture, Quintiles, Sristek,
Do you need to rearrange the order of the data for the report?
Describe crosslist option in tables statement?
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
how can you improve the performance of a query, If it is excuting very slowly?
Teradata 
