topic Re: how take number with one decimal in SAS Programming

how take number with one decimal

thanikondharish — Tue, 21 Jul 2020 15:19:21 GMT

data ex;

a=23.964 ;

run;

create new variable and should be in numeric format only

how to directly we can divide the number number with one decimal

ex: 23.9

Re: how take number with one decimal

Kurt_Bremser — Tue, 21 Jul 2020 15:26:26 GMT

Just use a numeric format with one decimal, e. g.

format a 8.1;

Re: how take number with one decimal

ballardw — Tue, 21 Jul 2020 15:40:53 GMT

b = floor (a*10)/10;

if the object is to always round down to multiples of 0.1

otherwise you may need to provide more rules.

Re: how take number with one decimal

mklangley — Tue, 21 Jul 2020 15:59:03 GMT

Truncation without rounding:

data ex;
   a = 23.964;
   b = int(a*10)/10;
run;

See helpful article here.

Re: how take number with one decimal

thanikondharish — Tue, 21 Jul 2020 16:07:46 GMT

Sorry I need exact number If I use your format it is showing 23

Re: how take number with one decimal

PGStats — Tue, 21 Jul 2020 16:37:20 GMT

data ex;
a = 23.964 ;
b = round(a, 0.1);
c = int(a*10)/10;
format b c 8.1;
run;

proc print; run;

Obs. 	a 	b 	c
1 	23.964 	24.0 	23.9

Re: how take number with one decimal

PaigeMiller — Tue, 21 Jul 2020 16:54:13 GMT

Just remember that by converting to 23.9 using the above methods (except formatting), this number cannot be represented exactly in binary, and so that may cause issues.

Re: how take number with one decimal

Kurt_Bremser — Tue, 21 Jul 2020 18:07:20 GMT

@thanikondharish wrote:
Sorry I need exact number If I use your format it is showing 23

Bullshit. See @PGStats post (variable c).

Re: how take number with one decimal

mklangley — Tue, 21 Jul 2020 18:27:18 GMT

@Kurt_Bremser I believe applying format 8.1 would actually cause a to show up as 24.0 (not 23.9, as in @PGStats's example c), since rounding is also applied. But it would definitely have a digit after the decimal point, like you indicated.

data ex;
    a=23.964 ;
    format a 8.1;
run;
proc print; run;

Re: how take number with one decimal

Kurt_Bremser — Wed, 22 Jul 2020 07:22:50 GMT

@thanikondharish wrote:
Sorry I need exact number If I use your format it is showing 23

On top of what was already said, this (rounding up) is mathematically correct behavior for values where the first "discarded" digit is 5 or greater, and should usually be applied.

"Exact number" is of course a very funny term when you are actively reducing precision in the first place. By applying a format with a limited number of digits, you have already thrown the concept of "exact" over board.

Re: how take number with one decimal

Ksharp — Wed, 22 Jul 2020 13:33:23 GMT

proc format ;
picture fmt
 low-high='0009.9';
run;

data ex;
a = 23.964 ;
format a fmt.;
run;

proc print;run;