topic Re: Strip from decimal to right from a numeric field in SAS Enterprise Guide

Strip from decimal to right from a numeric field

carmendee — Tue, 15 Dec 2015 21:22:35 GMT

In need to round down to the nearest whole number or simply strip everything to the right of the decimal in a numeric field. Example:

have	need
1.2	1
0.1	0
10	10

Re: Strip from decimal to right from a numeric field

mohamed_zaki — Tue, 15 Dec 2015 21:33:35 GMT

Use the FLOOR function to round down to the next integer.

data a;
  input have;
  need=floor(have);
datalines;
1.2
0.1
10
123.456
34
5.1111
7.68
10.98
-3.1
-19.0
-4.8
;

proc print;
run;

Re: Strip from decimal to right from a numeric field

advoss — Wed, 16 Dec 2015 20:10:26 GMT

Remember that the floor function gives you the next lower number, so 3.1 yields 3 and -3.1 yields -4. The int function will give you 3 and -3 respectively. So, choose the one that meets your specific needs.