topic Decimals in SAS Procedures

Decimals

fredbell — Thu, 29 Jul 2010 12:42:23 GMT

Morning!

I have a number 41.2 and i want it to show as 41 removing everything after the decimal, can anyone help?

Thanks

Fred

Re: Decimals

Doc_Duke — Thu, 29 Jul 2010 12:59:57 GMT

If you want to actually remove the decimal part, then the function to use is FLOOR. If you just want to display it without a decimal, then just use a format, like
FORMAT myvar 3.;

Re: Decimals

fredbell — Thu, 29 Jul 2010 13:16:53 GMT

Hi Duke

Sorry for my lack of knowledge, how can i incorporate the FLOOR into the below code?

Fred

proc sql;
create table TVStats as
select
mean(TvAverage_Speed_of_Answer__Sec_) as Tv_AvgSpeedofAnswerSec
FROM Cscore.tv;
quit;

Re: Decimals

OS2Rules — Thu, 29 Jul 2010 14:07:31 GMT

Hi All:

Not to go off-topic, but I have a similar question. How do I get just the mantissa of the floating-point number - other than subtracting the figure from its' integer? I could have sworn that there was a function (like the opposite of int() ) that would do it.

Re: Decimals

Doc_Duke — Thu, 29 Jul 2010 14:48:35 GMT

FredBell: Just add the floor to the Mean line
FLOOR(mean(TvAverage_Speed_of_Answer__Sec_)) as Tv_AvgSpeedofAnswerSec

OS2 Rules: please start a new thread.

Re: Decimals

fredbell — Thu, 29 Jul 2010 23:23:26 GMT

Thanks for your help Duke.

Fred