How did you use the round function?give an example(don't
say it will round to the nearest intger) eg1:round(84.55,.1)
=84.6 eg2:round(92.64,.1)=92.6,How it is happening like
this tell me the logic,that is how the round function works
when we have deimal values?
Answers were Sorted based on User's Feedback
Answer / unknown
round fuction works such that the first argument in the
fuction is to the nearest multiple of the second argument
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / learner
Round function rounds to nearest point according to given
significant limit.
EX1 round(84.55 , .1) in this case the significant limit
given by you is .1. so it will round upto one decimal value
(aa.a). Since the value is .55 it returns .6 . then the
output is 84.6(84+.5+.1)
Ex2 round(92.64, .1) the value that is need to be rounded
is .04 and less than half of significant value it returns
0. so total valu is 92+.6+.0=92.6
I hope it will help you
| Is This Answer Correct ? | 14 Yes | 6 No |
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.
What is a post baseline?
Explain the use of proc print and proc contents?
what is portability of sas programmes?
what are different analysis datasets you created and what are the new variables created
What statement do you code to write the record to the file?
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
how sas deals with business intelligence? : Sas-bi
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
how will you location sas platform applications available from web browser? : Sas-bi
How can I remove header from output data set?
what is Difference between PROC SQL JOINS and MERGE?