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
- 18449 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 |
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
What is the use of stop statement?
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
How do handle working under pressure?
What is the difference between nodupkey and nodup options?
Are you involved in writing the inferential analysis plan? Tables specfications?
How would you remove a format that has been permanently associated with a variable? ________________
What are the different versions of sas that you have used until now? : sas-grid-administration
why is sas considered self-documenting? : Sas programming
How do you debug and test your SAS programs?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Name the option to produce a frequency line items rather that a table.
Teradata 
