What is the significance of the ‘OF’ in X=SUM (OF a1-a4,
a6, a9);?
- 8 Answers
- 16311 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how you can debug and test your SAS program?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Describe the function and utility of the most difficult SAS macro that you have written?
How would you identify a macro variable? : sas-macro
What commands are used in the case of including or excluding any specific variables in the data set?
How would you include common or reuse to be processed along with your statements?
name some data transformation used in sas di? : Sas-di
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What are the five ways to do a table lookup in sas? : sas-grid-administration
Explain proc univariate?
What are types of transport files?
what is enterprise guide? What is the use of it? : Sas programming
